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 |
|
cnaypi
Starting Member
22 Posts |
 Posted - 2008-08-21 : 15:58:44
|
| I am trying to insert bulk data to a new Column that I just created what is the proper statement to achieve what I'm trying to do.Info:Table name is BOOK2Column name where I want to insert bulk data to is IDEALThe data I need to insert in my local harddrive saved in Excel. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-08-21 : 16:01:14
|
quote:
The data I need to insert in my local harddrive saved in Excel.
You either need to move the file to the database server or use a full unc path. This is because BULK INSERT runs from the database server's perspective and not from your local machine. See SQL Server Books Online for details on BULK INSERT command.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
|
|
|
Bulk Insert Assistance