Importing with a primary key

  • Thread starter Thread starter ksheele
  • Start date Start date
K

ksheele

I am using the TransferText function with a specification name to link/import
a large textfile. Sometimes a primary ID is attached to the resulting
database; sometimes, it isn't. How can I get it to always (or never) attach
the primary ID?
 
Please clarify -- is the primary key in the text file, or is it in the table
into which you import the text file's data?
 
The primary key needs to be in the database that results from the import.
The file is large enough that I was unable to paste onto a new database with
an index without running into memory problems, but I circumvented the problem
by restricting myself to only pasting the relevant records onto the new,
indexed table. That is working for now.
 
Back
Top