I have a access 2000 vba code, which created a report from a custom made query. I use a TransferSpreadsheet method to run the query and export the result into a xls file. Now my user want the result to be in csv format.
Should I write new code that convert the existing xls file to csv and delete the xls, or, should I just dump all the xls code and write code to create csv report?
I tried some method found in the internet such as TransferText but it ended up having error. I though it would be easier to convert the xls report into csv and delete the xls file.
What do you think?