BULK INSERT help

[pengu]

Having some problems with BULK INSERT *shudder*

 

Got some data off a client, emphasis on some which is where my problem is.

 

The table I want to insert into is the following.

I'll do an example of the data this text file contains. Using the table.

 

client_id	first_name	last_name	address1	city	postal	plate_number	email	phone	id2	desc
	mark		turner		123 fake st	bris	4600							

 

A lot of information is missing.  Now when I try to do a BULK INSERT.

BULK INSERT Client_Desc
    FROM 'c:\clients.txt' 
    WITH 
    ( 
        FIRSTROW = 2, 
        FIELDTERMINATOR = '\t', 
        ROWTERMINATOR = '\t\n'
    )

 

I get the following error.

 

Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 2, column 1 (Client_ID).

 

Which is to do with the Client_ID which is Auto Increment.  Any suggestions or am I manually going to have to write up the insert line for each client, which works..

[spambadger]

I've not done this before, but apparently you can use a format file to achieve what you require, there's some help here: http://msdn.microsoft.com/en-us/library/ms178129(SQL.105).aspx