primary key

[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

 

[cogent1]

don't think it's possible...

it appears that this can't be done using a saved import spec. You can't even manually add an autonumber field to the spec as far as I can see. Strange, eh?

It's easy enough to add the primary key manually after the import though, or use a simple procedure to add it automatically.

 

[namliam]

Or .... simply import the file into a waiting table which allready has an auto key in it...

Another thing ... dont use macros for this kind of thing.... Go VBA you will in do it in the long run anyway ....

Regards