August 19, 2016 at 2:37 pm
I am working with a small manufacturing company that uses a shop system with an SQL database to keep track of their orders and parts. The company that created our system recently came out with an upgraded version of the system that we are interested in switching to. Unfortunately, only a small portion of the data in our SQL database will be converted to the new database. I have been making append queries in Access to transfer the remaining data for us. However, I have come across an issue that one of the new tables from the new database is not able to be linked with MS Access. Access says there are too many indexes to link the table. So my question is, has anyone figured out a workaround for this? I know you can run a Pass-Through Query to see the data in a non-linked table, but I can't figure out any way to make a sort of Pass-Through Append Query. I am very new to Access and SQL Servers in general, so I am also wondering if there is any front end to the SQL Server itself that would allow me to append the data without actually using Access, but rather SQL Language. All help is much appreciated.
August 23, 2016 at 3:08 pm
You could use SQL Server Management Studio to import from MS-Access.
Connect to the SQL server, click the Databases node to expand the list, right-click on your database and select Tasks ~ Import Data which brings up the Import & Export Wizard. Select the Data source = Microsoft Access and the follow the rest of the wizard. HTH
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply