We currently have an Excel Spreadsheet which reads cells, then checks a foxpro dBase database if the data exists and if it doesn't, it inserts it into the FoxPro dBase Database.
The FoxPro dBase database has been REPLACED with a SQL Server 2005 instance and so the VBA must be adjusted to read the SQL Server Database.
Only 3 tables are inserted/updated in this process.
The changed VBA must therefor:
1) Setup the Connection to the SQL Server
2) Check is the record exists (as it does in the old code)
3) Depending if it exists, either insert or update (as it does in the old code)
This project is very very small. Changes are only expected in one 1 module.