I am trying to find a workaround for a formatting issue I'm having. I
download data from a financial system that comes out as an ASCII fixed format
file that we save as a .txt file in notepad. We then use an import macro in
an Access db to upload this financial info to our db. So, here's my
question, the method with which we download will be going away, to be
replaced by a web-based query that delivers the information either as an
Excel file or a CSV text file. I need to make the data it delivers look
exactly like the formatted data I get from the financial system. Is there
any way to somehow capture the exact formatting from the download and apply
that to the future data we'll be getting via query? If not, any other
suggestions other than re-writing the Access import macro?