Monday, September 1, 2014

can you insert into a table without having the table structure in place

I have tried to use the import wizard insert data in a CSV file into a table;


I have 7 column headers, however, where there are extra commas in a field the wizard just combines the 2 fields so that i get a total of 7 columns even though there should be more.


any ideas how i can round this problem?


should i use bulk copy?




sukai


No comments:

Post a Comment