Hi all,
I am working on a query and need to export the table as CSV and I was surprised to see that was not an option in access. I have been trying many different options to get it to work. ( export as text etc). Short of exporting to excel then converting an extra step I do not want to have to do. Does anyone have a macro that will work? Also is there another version to eliminate the . Some reports I need the headers and others I do not. thanks for your help in advance.
I am working on a query and need to export the table as CSV and I was surprised to see that was not an option in access. I have been trying many different options to get it to work. ( export as text etc). Short of exporting to excel then converting an extra step I do not want to have to do. Does anyone have a macro that will work? Also is there another version to eliminate the . Some reports I need the headers and others I do not. thanks for your help in advance.