• 0

Macro in Access


Question

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

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.