Automatic importing of text files

[Dustin Swartz]

Does anyone have an example of a macro that will auto import a text file
upon execution?

Also the text files that I am dealing with contain the "Column Header" as
"row headers"

In other words the first record in the first columns of each row needs to be
my column name. Any ideas how I can format such aninput?

Thank you.

 

[John Nurick]

Hi Dustin,

It's the TransferText macro action or the DoCmd.TransferText VBA
statement. Details are in Help.