Import Text - Macro Issue - Semi-Colon Delimited

[Guest]

I am having trouble making a macro import semi-colon delimited text. Access
is wanting to automatically import using comma delimited, which is completely
fouling up my import.

How do I make an Access macro import a text file in semi-colon delimited
format instead of the default comma format?

Thanks!!!

 

[SusanV]

You need to create an import spec by manually importing the file and saving
the specification. Then you can import the file with TransferText using the
specification you created.

 

[Guest]

You will need to establish an Import Specification. The Help files clearly
explain how this is done.

Sharkbyte