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 |
|
imughal
Posting Yak Master
192 Posts |
 Posted - 2004-09-22 : 06:49:23
|
| hi,i have excel fiel contain data in column format like thisOrder ID Line ID Product ID Product Code Quantity Unit Pricei have to read the excel file and insert data to sqlserver from excel file. how i can do this. either use bulk insert or dts package. any help will be appreciated. |
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
|
|
|
|
|
Bulk insert from excel