>>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!
>
>If you use APPEND FROM then you may specify exact field list.
>>Tommy

Thanks!! I will test it out later today when I get some time available.

Tommy