September 30, 2011 at 3:13 pm
Hi, I have an excel file which I would like to import into the sql server database.
The data in the excel sheet starts from row 8 and so I would like to import the data from row 8.
1- What task do I do for this import
2- should I use a bulk insert task for excel. When I use this task, I tell it that the rows start from row 8. but the error I get during run time is that one of the fileds in the excel file is long. Not sure what this refers to?
October 3, 2011 at 8:59 am
It's not clear whether you would like to do this once or on regular basis.
Anyhow to share my experience- Run Sql Server Import and Export wizard and before Run save Package-
you can use it later any time
October 3, 2011 at 9:45 am
Solved. Thanks
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply