Bold.Codes

Database 47 To deal with database and maintain it

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

Nov27

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

Oct13

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

Sep3

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

Jul19

What is the Driver part in ConnectionString

Jun2

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

Apr23

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

Apr22

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

Apr12

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

2022Dec23

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

2022Sep25

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

2022Sep15

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

2022Jul24