May 10, 2009 at 9:32 pm
Hello,
I've got a task that requires me to adding data from excel sheet into SQL server 2005. The excel sheet contains data which has more than 2000 rows with different columns. These data need to be inserted in more than one tables.
I was suggested to use "OpenRowSet" to do this, but i'm not sure how this works.
Could someone please advise me the best way how to do this?
Cheers
May 11, 2009 at 2:59 am
you can use SQL Server Import and Export Wizard. Then write a query to specify the Data transfer (Which columns should be added).
May 11, 2009 at 5:13 am
You can use SSIS for this you will need to setup an excel data source then use a task to split out the data to the correct destination table.
You will need a way to identify what rows are meant to go to each table, do you some way of identifying this?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply