3 functions to add or update data to DB and Read from DB. These were also ...
2023Apr23
Records affected by sql Execute command https://docs.microsoft. ...
2018Sep1
Returns random IDs (or any column) from SQL Database table, passing number of ...
2018Jul29
Checks if ID has been reset in SQL database table If yes, it will reset it and ...
2020Mar31
Creates SQL INSERT statements from a table in Excel. Used to be executed to ...
2022Jul3
How to reset ID Column in Microsoft SQL, (not completed yet). This is because ...
2020Feb9
SQL select statement to convert list of IDs found in column (from more than row ...
Jan20
Allows users to inserts image into sheet, replacing old one, with ability to ...
2021Feb20
Counts how many cells matching 2 criterias.
Just like
May1
Listing the file from a folder that was created during last few hours. Can ...
Apr30
A simple graphic illustrates the new HTML5 tags and differences against old ones
2021Apr16
Fix broken Arabic char, by using AscW and ChrW This is Excel User-defined ...
2018Jul25