ANmaVLookup

Finds first occurrence of item in column, then returns value from same row as ...

ANmaRemoveDuplicates

Removes duplication in table in 1 or more columns. Will work in sheet, ...

ANmAdvancedFilter

Filter table inside Excel the fast way (using advanced filter) into another ...

ArrSort_3Arr

Sort 3 arrays, ascending or descending based on 1st array. Needed for specific ...

SQL Related posts

Steps to create related posts query in SQL. Index, catalog, matching posts for ...

ANmaSQL_UpdateDateStatement

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

ANmaSQL_InsertStatement

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

DBTable2CSV

Exports table into CSV from ASP Classic function.

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