April 3, 2012 at 1:08 pm
Hi,
I designed a database that consists of tables and Junction tables (many to many) so the database schema is already designed with predetermined datatypes. We have been collecting data using Excel. So each worksheet corresponds to each table in my SQL database and the columns to the fields in the database tables. I can't seem to find a solution where I can import the whole workbook at once. I tried SSIS successfully but one table at a time. Is there a way I can build a package to import the whole workbook into SQL?
thanks
April 3, 2012 at 1:59 pm
If you run the SQL Server Import and Export Wizard and select your excel file you should get to a screen called 'Select Source Tables and Views' that will show you all the sheets in your and then you will be able to select the corresponding existing table. Then save you package. Let me know if that helps (or not).
April 3, 2012 at 3:05 pm
Using Export - import wizard, I am able to import excel sheet with more that 10 worksheets. All the first raw in the excel sheet will be treated as header if you want. You can even save the it as SSIS package too.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply