| re: cannot import delimited text programmatically (macros) with automatic primary key generation
Don't import to a new table, creating the table as you go along.
Instead, import to an _existing_ table, and you're done!
praz wrote:[color=blue]
> I am trying to import a delimited text file using a macro. The problem
> is i am not able to generate a Primary key (Let access add primary
> key). I have tried saving the import specs using the import wizard and
> specifying the same in the macro, but when I run the macro, the text
> file is imported without the ID field (Primary key field).
> Please any help appreciated.[/color]
| 
