Autonumber key with text files

  • Thread starter Thread starter Graham Bennet
  • Start date Start date
G

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
 
Hello,

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

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


John Vinson said:
Use File... Get External Data... Link to link to the textfile, and run
an Append query appending all fields *except* for the autonumber.
Click to expand...
 
Back
Top