Import Text - Macro Issue - Semi-Colon Delimited

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!!!
 
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.
 
You will need to establish an Import Specification. The Help files clearly
explain how this is done.

Sharkbyte
 
Back
Top