CSV IS a particular form of text format...

It means Comma Separated Values where in different fields are separated by
commas...

If the CSV output matches the format you get your txt file now, then you
should be good to go... otherwise you might need minor tweaking.

If it is being developed by another group for you then you can ask them to
give it in the same format as you have now... you will just need to change
the extension from CSV to TXT then...



"Decembersonata" wrote:

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?