Automatic importing of text files

  • Thread starter Thread starter Dustin Swartz
  • Start date Start date
D

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.
 
Hi Dustin,

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