Using BCP to Import

[minckle]

Hi

I'm using the BCP facility to import a text file into a database. My problem is, in the table there are 10 fields but my file only contains data for 3 fields

e.g
Table - id,forname,surname,dob,gender,mob_number
File - forname,surname,mob_number

is there a way of only importing into the required fields or do i have to have columns in the order they are in, in the table????

can I use this file??
matt,jones,0775446644
chris,jones,066565465

or do i have to use this???
,matt,jones,,,0775446644
,chris,jones,,,066565465
Edit/Delete Message

[rmiao]

Other columns accept null value?

[nosepicker]

If you use a bcp format file, you could then choose which columns to ignore. Otherwise, you'd have to use your second method (matching the column positions with the data).