DB Functions (By AI)
3 functions to add or update data to DB and Read from DB.
These were also generated by Bing AI, so need work to convert to proper functions.
SaveRangeToDB: Inserts range (as table) from spreadsheet to SQL table.
UpdateTableFromDB: Updates SQL table with records from spreadhseet table using 1st column as ID.
GetDataFromADO: Reads table from SQL DB into spreadhseet.