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 |
|
jwaz1999
Starting Member
12 Posts |
 Posted - 2010-09-10 : 12:44:58
|
| Is there a way that a CSV file can be imported into a SQL Server table using BCP if the file has the below 5 column format, or do you have to iterate through it one record at a time?sample data:5, "test, column", "test column 2", 4, "test column, 5"6, test column", "test column 2,", 5, "test column 5"7, test column", "test column 2", 6, "test, column 5"If it can be done with BCP, how do you define the format for columns with quotes(char data) and columns without quotes(int data)?Thanks,Jeff |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
jwaz1999
Starting Member
12 Posts |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
jwaz1999
Starting Member
12 Posts |
|
|
|
|
|
|
|
Import CSV file