Database 61

To deal with database and maintain it
Sorted from new to old.
Card image cap
SqlExec

Runs SQL Command that needs no return This is primarily useful for CREATE, ...

Card image cap
Refresh Table from View

Convert SQL View into table for speed reading. Using views a lot, I needed a ...

Card image cap
DB connection driver

What is the Driver part in ConnectionString

Card image cap
DB Functions (By AI)

3 functions to add or update data to DB and Read from DB. These were also ...

Card image cap
WordPress - Excel functions (AI)

3 functions to download posts, adds new post and to upload and set featured ...

Card image cap
Arabic in MySQL

Here is how to read Arabic text from MySQL db from Classic ASP I tried a lot ...

Card image cap
ANmaVLookup

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

Card image cap
ANmaRemoveDuplicates

Removes duplication in table in 1 or more columns using Excel ...

Card image cap
ANmAdvancedFilter

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

Card image cap
ArrSort_3Arr

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

Card image cap
SQL Related posts

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

Card image cap
ANmaSQL_UpdateDateStatement

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

Card image cap
ANmaSQL_InsertStatement

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

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 ...