Problems with the Transfer Text Macro

[RobertM]

Hello:

I've got a text file that I need to import into access. It imports fine with
the wizard, but I've tried to set up the Transfer Text macro and I'm having
problems. One one run of the macro it reduced the table to one feild with all
of the data jumbled into it. Subsequent runs give me an error message. Can I
have some advice on using the transfer text macro? Using the wizard is not an
option I can give to the end users.

Thank you!

 

[Ken Snell \(MVP\)]

If you do not use an Import Specification in the TransferText action, ACCESS
will assume that the delimiter is a comma. If there is no comma in the line
of data in the text file, the entire line will be put into a single field.

You can create an Import Specification by beginning the import process
manually (File | Get External Data . . . | Import). When you've set all the
settings (delimiter, fields, etc.), on the last screen before you actually
do the import, click the Advanced button at bottom left of window. Then save
all the settings as a Specification (give it a name). You then can cancel
the import.

Use that specification name in the Specification argument of the
TransferText macro action.