cannot import delimited text programmatically (macros) with automatic primary key generation

Hi,

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.

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]