txt file has no pk and the table needs one

[smith7255]

Hello -
I have a txt file that I need to import into a table in Access. I have created an import spec, but the file doesn't have a pk. I need one in the table but the file will not import (using a macro) because the fields are not the same. Now, I can do it manually because it asks me if I need on, specify my own or don't need one. That just creates an ID field in the table and the problem comes around again because the file doesn't match. How can I get a pk using autonumber on an import like this?

 

[dhookom]

You can import into a temporary table and then append to a table that has an autonumber primary key.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[smith7255]

Thank you for your help, but I actually hid the ID column of that table and it was able to import. Although this does not work with exporting. I will just create a query that doesn't include the ID column and then export that instead.