>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
Edward Pikman
Independent Consultant