macro action "TransferText" Add primary key

[Morris]

Trying to create macro action "TransferText" cannot figure out how to add
"Primary Key (Autonum)" when importing the text .just as I would do it at
"external data" import ..Can anybody give me an idea?

 

[Steve Schapel]

Morris,

Do you have an Import Specification set up for this transfer? And are you
importing to an existing table?

 

[Morris via AccessMonster.com]

YES I set up an Import Specification for this transfer, but I was not able to
get the primary key to be included in the Import Specification.
YES I am
importing to an existing table.

 

[PieterLinden via AccessMonster.com]

YES I set up an Import Specification for this transfer, but I was not able to
get the primary key to be included in the Import Specification.
YES I am
importing to an existing table.

Morris,

[quoted text clipped - 4 lines]

If you have an autonumber primary key, you don't want to include it in the
import specification. Access will supply a value for you.

 

[Morris via AccessMonster.com]

Sorry I have to correct myself I am importing to a NEW table. My original
file does not have a autonumer I want to add it when it gets imported to
access.

YES I set up an Import Specification for this transfer, but I was not able to
get the primary key to be included in the Import Specification.

[quoted text clipped - 6 lines]
If you have an autonumber primary key, you don't want to include it in the
import specification. Access will supply a value for you.

 

[Joan Wild]

You can import the data to a table, and then run an append query to add
that data to another table that does have an autonumber field in it.

Joan Wild

Sorry I have to correct myself I am importing to a NEW table. My original
file does not have a autonumer I want to add it when it gets imported to
access.

YES I set up an Import Specification for this transfer, but I was not able to
get the primary key to be included in the Import Specification.

[quoted text clipped - 6 lines]

"Primary Key (Autonum)" when importing the text .just as I would do it at
"external data" import ..Can anybody give me an idea?

If you have an autonumber primary key, you don't want to include it in the
import specification. Access will supply a value for you.