Hello,

I have successfully done what I wanted to do with the Format File.

My Table had 3 fileds. IDENTITY, code and description.

The CSV file had two fields, code and description.

Here is...

Thank you very much for the link.

I had been working on another solution using views.

Here is my script.

create view v

as

select code, description from Category

go

master..xp_cmdshell 'bcp tempDB..v in c:\crimcode.csv...

Thank you very much for the reply. But how do I use a format file in Bulk Insert? Searching for BOL did not give any results in SQL Server help.

Really...

Hello,

I have the same problem at my end where I need to bulk upload into a table with an IDENTITY.

I can see both the solutions you guys are suggesting.

1....