Andy,

Must be fixed width fields, otherwise you could spedify the delimeter in the BCP command. In the case of fixed width files, you could bcp into a generic table:

create table Import

( id int identity primary key,

data varchar(4000)

)

Then parse the data field as needed in sql. Just an option.

John