Hey Guys!

I was wanting to import a large text file (comma delimited) into a table.

The first field in the table is an autoincrementing field.

When I import the data, the data acts like field 1 went into the AUTOincrementing field (yikes!), field 2 to where field 1 is suppose to go, field 3 to where field 2 was suppose to go.....

Sample text file....

UPC    Name    Amount    Class
40001 ,Joe    ,20.0     ,A
60002 ,Mary   ,31.2     ,B
20003 ,Gary   ,44.3     ,C


When imported into the table.....
Table foo

Rec_ID          UPC     Name      Amount      Class
AutoIncrement
1               Joe     20.0      A
2               Mary    31.2      B
3               Gary    44.3      C

Will I have to REMOVE the Autoincrementing field, or move it to the END of the table??

Thanks!
Tommy