transfer text and add primary key

W

weisd

I can import a text file manuly with no problem using saved import specs. and then letting access ad the primary key. But when try to do this action using a macro I cannot see how to let access add the primary key.

Access 2000 9.0
 

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

VBA word change keys 0
macro action "TransferText" Add primary key 5
Why won't Access assign a Primary Key ID to my linked SQL Table? 2
Import text file with macro - Invalid argument (Error3001) 0
Add a primary key via a macro 1
primary key - concatenated or autonumber? 6
Import with access defined primary key from macro 1
macro to delete duplicates and Primary Key 0

Top