Importing with a primary key

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?
 
K

Ken Snell \(MVP\)

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?
 
K

ksheele

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.
 
Top