I am writing an access 2003 application that needs to process data in a text file that is sent from a vendor each month. (I have attached a sample with names changed to protect the innocent)
The text file is tab delimited and with have the same format column wise. The row count will be different each month
My first thought was to import the text file and save as an excel spreadsheet but wasn't sure of the best way to do that.
I am open to other ideas as well