Autonumber key with text files

[Graham Bennet]

Hello,

When importing data from a text file, does anyone know how to import the
data
to a table that uses a autonumber key.

Thanks, Graham

 

[John Vinson]

Hello,

When importing data from a text file, does anyone know how to import the
data
to a table that uses a autonumber key.

Use File... Get External Data... Link to link to the textfile, and run
an Append query appending all fields *except* for the autonumber.

 

[Graham]

Thanks John

Use File... Get External Data... Link to link to the textfile, and run
an Append query appending all fields *except* for the autonumber.