My original Access system had some automation, which added some tables to the DB that were linked to an Excel spreadsheet. These tables were then imported into the permanent tables in my DB.
I still need to import data from the spreadsheet to my DB but it is all now split. The DB is on a SQL Server on another computer.
Is there a way to create a linked table on the SQL server and import everything from the spreadsheet? I probably need to do this through code in my ADP file.
I still need to import data from the spreadsheet to my DB but it is all now split. The DB is on a SQL Server on another computer.
Is there a way to create a linked table on the SQL server and import everything from the spreadsheet? I probably need to do this through code in my ADP file.
