Importing multiple text files in different formats

[mims]

Hi,

I am tryig to import many text files into MS Access. They are all tab delimited and have NO column headers, but they all have varying number of columns and data types.

Rather than using the Import wizard for every single text file, is there a way to write some code in VBA to upload the file, which I can then just edit as neccessary for each type of file?

Thanks for your help.