Hi,
I need to import data from a pipe delimitted text file to a table. I'm using bcp to do the same.
The input file contains header, data record and footer.
header and footer contains 12 columns, where as data record contains 15 columns.
I'm using -F option to ignore the header, but it is ignoring header and a data record as well.
I have gone through the posting where they are suggesting a workaround of :
1. Import each row to a column in a temporary table
2. delete the header and footer from the table
3. export the data in table to a text file
4. Import the data in text file to destination table.
Is there any other workaround apart this ?
Thanks
MLP