Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2011-09-30 : 17:07:27
|
| 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? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2011-10-02 : 00:59:08
|
| Thanks |
 |
|
|
|
|
|
import excel data