I am importing data into a database from a flat file using BCP with a format file. I have to use BCP for the process. The file has a couple of columns that are CRLF delimited with a blank line between rows. In some records the last column was dropped off and isn't there (an example below. I do not know how to make it skip that column if it is not in the file. Help!
Example:
1
Mike
Thomas
Male
2
Terry
High
Female
3
Rob
Miller
4
Steve
Jobs
Male
Example:
1
Mike
Thomas
Male
2
Terry
High
Female
3
Rob
Miller
4
Steve
Jobs
Male