|
jwaz1999
Starting Member
12 Posts |
 Posted - 09/10/2010 : 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 |
|
Import CSV file
