DBTables

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

CSVs2Sheets

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

CSVs2Sheetsv0.2.xlsb.zip

SumOf_3Filters

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

RRRow - Datatables ASP mdb Ajax example

ASP based AJAX example to call mdb database using

RRRow-asp-mdb-Ajax.zip

NextID_Reset

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

DB_Connect_Install

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

DB_Connect_Install.zip

DB_Connect

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

Reset ID Column

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

ANSQLWherein

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

List of Databases

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

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

Rows 2 Cell

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