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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Gantt task bars not printing 2
Populate primary key into imported tables 1
No error on docmd.transfertext when expected 1
Why won't Access assign a Primary Key ID to my linked SQL Table? 2
Importing SSNs from Excel into access 2007 and using as primary ke 1
Import with access defined primary key from macro 1
don't import duplicates based on several fields 7

Top