Database 66

To deal with database and maintain it
  2. Categories
  3. Database
Sorted from new to old.
Card image
ANmaSQL_UpdateDateStatement

Creates "Update Table " SQL statements to be executed inside SQL to modify ...

2022Jul4
Card image
ANmaSQL_InsertStatement

Creates SQL INSERT statements from a table in Excel. Used to be executed to ...

2022Jul3
Card image
DBTable2CSV

Exports table into CSV from ASP Classic function.

2022May31
Card image
DBTables

Returns an array of all table names in a database. needs valid OLE database ...

2022Apr28
Card image
CSVs2Sheets

Import all CSVs found in a folder into sheets, sheet per CSV This was a quick ...

2021Oct5
Card image
SumOf_3Filters

Returns sum of certain column in range (or table) in sheet after applying ...

2021Jan29
Card image
RRRow - Datatables ASP mdb Ajax example

ASP based AJAX example to call mdb database using

2020Sep7
Card image
NextID_Reset

Checks if ID has been reset in SQL database table If yes, it will reset it and ...

2020Mar31
Card image
DB_Connect_Install

Connects to SQL DB using ADODB, if driver not installed, it will attempt to ...

2020Mar24
Card image
DB_Connect

VBA-Excel function to connect to SQL Database server, in addition to ...

2020Mar20
Card image
Reset ID Column

How to reset ID Column in Microsoft SQL, (not completed yet). This is because ...

2020Feb9
Card image
ANSQLWherein

Creates list of items to be used in ' Where item in (List)' list Mainly adds ...

2020Jan6
Card image
List of Databases

Script to list databases available in a server using ADODB connection From

2019Oct6
Card image
Country list in arabic

List of countries codes and names in Arabic, you do not know when you need it ...

2019Sep9
Card image
Rows 2 Cell

Convert items found in a column matching certain material into list in 1 cell ...

2019Jul30
Card image
DB_ExtendedProperties

Returns extended properties of a database, knowing the ADODB connection

2019Jul22
12345