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.
Access is limited.
Login here using your Linkedin account. to see or download code.
No registration, not another password to remember, login using your Linkedin account and have access to all public codes in Mydev.net
Linkedin Login
Views 1,727
Downloads 140
CodeID
DB ID
