Importing with a primary key

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ksheele - 12 Dec 2007 21:09 GMT

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?

Signature

ksheele

Reply to this Message

Ken Snell (MVP) - 18 Dec 2007 00:27 GMT

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?

Signature

Ken Snell
<MS ACCESS MVP>

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

Reply to this Message

ksheele - 28 Dec 2007 16:23 GMT

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.

Signature

ksheele

> 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?
[quoted text clipped - 5 lines]
> > attach
> > the primary ID?

Reply to this Message