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 to code 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 Bold.Codes
Login
Views 5
Downloads 0
VBA-Excel
