|I have a database in SQL Server that already has tables and data in it. I also have and Excel 97/2000 workbook which has sheets named corresponding to the tables and data in it.|
I am using an Access ADP file to connect to the database and work with the data, but also can get directly at it through SQL manager if needed.
What I would like to do is import the data from the excel sheets to the database tables. The only way I can find to do this is using the "Get external data" menu option in Access, but this only lets me do one table at a time. Is there a faster way to get everything imported?
Free Computer Tips and more:http://RyanTAdams.com
Paid Tech Support: Black Diamond