I have a large number of ascii files stored in a folder c:\tmp.
Each file has four columns seperated by tabs. There is no header row.
Here are a few rows from one file:
08/13/2004 AAC.AX 1.4 7212730
08/16/2004 AAC.AX 1.4 675351
08/17/2004 AAC.AX 1.4 161616
I want to import the contents of these files into a single table, using the same column order.
Is there a quick and easy way to do this using Access VBA?