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 |
|
Westerberg
Starting Member
18 Posts |
 Posted - 2006-04-06 : 13:53:53
|
| I'm trying to import a .csv file into a table using bcp. The command I'm using works for another file which is similar but doesn't seem to like this data file. The command is below and the error message is:SQLState = 3700, NativeError = 156Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'Dump'.bcp.exe operations.dbo.linc in c:\linc.csv -S[server name] -c -t, -Usa -P[password] The error message displays 7 times which is the number of fields that are in the data-file and obviously in the table as well. |
|
|
|
|
|
Import .csv using bcp