Import data from Excel workbook

Custom / NA
November 19, 2009 at 18:32:13
Specs: Windows 7, 3.5GB Ram
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?

-Ryan Adams

Free Computer Tips and more:
Paid Tech Support: Black Diamond

See More: Import data from Excel workbook

Report •

December 18, 2009 at 09:06:49
I think you should be doing this in SSIS. It is much easier to setup and automate. SSIS is included free in sqlserver license.

Report •
Related Solutions

Ask Question