Database 63

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

Reverses order of array. In other words, the upperbound value of an input ...

2023Nov27
Card image
ANmaFilter3

Filter database into new sheet, by copying certain columns only, not whole ...

2023Oct13
Card image
SqlExec

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

2023Sep3
Card image
Refresh Table from View

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

2023Jul19
Card image
DB connection driver

What is the Driver part in ConnectionString

2023Jun2
Card image
DB Functions (By AI)

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

2023Apr23
Card image
WordPress - Excel functions (AI)

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

2023Apr22
Card image
Arabic in MySQL

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

2023Apr12
Card image
ANmaVLookup

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

2022Dec23
Card image
ANmaRemoveDuplicates

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

2022Sep25
Card image
ANmAdvancedFilter

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

2022Sep15
Card image
ArrSort_3Arr

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

2022Jul24
Card image
SQL Related posts

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

2022Jul6
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
1234