Database 56 To deal with database and maintain it

Card image cap
DBTable2CSV

Exports table into CSV from ASP Classic function.

Card image cap
DBTables

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

Card image cap
CSVs2Sheets

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

CSVs2Sheetsv0.2.xlsb.zip

Card image cap
SumOf_3Filters

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

Card image cap
RRRow - Datatables ASP mdb Ajax example

ASP based AJAX example to call mdb database using

RRRow-asp-mdb-Ajax.zip

Card image cap
NextID_Reset

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

Card image cap
DB_Connect_Install

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

DB_Connect_Install.zip

Card image cap
DB_Connect

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

Card image cap
Reset ID Column

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

Card image cap
ANSQLWherein

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

Card image cap
List of Databases

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

Card image cap
Country list in arabic

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

Country-list-arabic-master.zip