Tags: bcp, causing, csv, dealing, file, ignore, import, line, programming, resolved, sql

BCP Import file - how to ignore top line

On Programmer » SQL

703 words with 1 Comments; publish: Thu, 29 May 2008 01:49:00 GMT; (20031.25, « »)

I have an earlier issue that has now been resolved, but now I am dealing

with a CSV file that is causing problems with my BCP import.

The csv file has column headers in the first row. Unfortunately, they

have spaces in the labels and the BCP utility cannot handle it. My BCP

command line says to start importing on line 2, but it still does not

like the spaces in the top row. Any suggestions besides modifying the

csv file since that is not an option?

*** Sent via Developersdex http://www.developersdex.com ***

All Comments

Leave a comment...