I have 13 queries that I export on a weekly bases. They are big queries and have a long process to export. I wanted to make a macro but ran into a few problems.
I need to export these with a spec and save them as csv files (however I can just save and txt and then just rename the extention. The only issue is, when I run the macro I created and export as .txt, it exports into an ascii format text such as this
| name | street |
_______________
| Jared | 12 Main|
Anyone know how I can accomplish this export via macro? can someone give me some useful vb code to do it? I want it to look like this when its exported
Question
Remote
I have 13 queries that I export on a weekly bases. They are big queries and have a long process to export. I wanted to make a macro but ran into a few problems.
I need to export these with a spec and save them as csv files (however I can just save and txt and then just rename the extention. The only issue is, when I run the macro I created and export as .txt, it exports into an ascii format text such as this
| name | street |
_______________
| Jared | 12 Main|
Anyone know how I can accomplish this export via macro? can someone give me some useful vb code to do it? I want it to look like this when its exported
header, header, header
data, data, data
Thanks in advance.
Link to comment
Share on other sites
1 answer to this question
Recommended Posts