I have created a custom database app that loads credit card data, reformats it some, adds a valid vendor number, and then exports it to a comma delimited file for upload into an accounting system. my last problem to fix is the fact that when the data is exported to a .csv file any text data that is actually numeric gets converted to a number automatically. I have tried several techniques for exporting the data including a macro and vba using the transfertext method, but all do the same thing. My current workaround is to export the data to a .xlsx spreadsheet, then manually open the spreadsheet and resave to a .csv. That keeps the text in proper format. I even tried the Function ConvertXls2CSV that I found online, but it did the same thing. I am wondering if newer file type of .xlsx to csv works properly but the convertxls2csv is using the older format and that is why that one does not work. Any alternative suggestions would be helpful.
Thanks.