Need to use VBA to create CSV comma delimited file for Access 2k
Posted on 2014-07-27
My access application has a problem and the Export Specification wizard will not work. I don't have the original disk so I need to create a CSV file from a query programmatically.
The column names of the query will change from time to time, but the name will not.
Can anyone help?
I guess I can use a maketable query then the recordset object to walk through the code, but I would think there should be a more straight forward approach. I tried using the recordset object to cycle through the query without any luck.
This is a weekend project for me, so I need to get this code working today.