Take the 2-minute tour ×
Programmers Stack Exchange is a question and answer site for professional programmers interested in conceptual questions about software development. It's 100% free, no registration required.

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?

share|improve this question
add comment

closed as not constructive by JeffO, Matthieu, Jim G., Mark Trapp, Walter Aug 30 '12 at 13:32

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance.If this question can be reworded to fit the rules in the help center, please edit the question.

1 Answer

You should be able to "Save As" .csv from within your VBA code.

Have a look at this article on how to set file formats Ron DeBruin

share|improve this answer
add comment

Not the answer you're looking for? Browse other questions tagged or ask your own question.