Automate query export?

[ExcessAccess]

The way I've been doing it, is that I designed a query, made it a make-table
query, and then I manually export the table as a tab-delimited .txt file.
BUT, I've come to realize that at this point, making the table is an
unecessary step (which takes up space), when I could just export the query.

Okay, I know there are disadvantages and negative connotations regarding
using Access macros. But forget about them, at least for this thread. Rag on
me later. lol, or not, whatever.

My antiquated upload process includes running this make-table query as the
last step in a macro [OpenQuery]. I don't want to make a table anymore. I
want to export directly from the query.

How can I amend my process? Is it possible to automate an export? VBA (which
I honestly don't know)?

Jarrod

 

[ExcessAccess]

I query a bunch of tables for data, to make a .txt file (products file) for
an online store (web).

 

[John Nurick]

Hi Jarrod,

Make a copy of the make-table query and convert it into a Select query
that returns the data that would have been put into the new table. Then
have your macro export the Select query instead of the table.

The way I've been doing it, is that I designed a query, made it a make-table
query, and then I manually export the table as a tab-delimited .txt file.
BUT, I've come to realize that at this point, making the table is an
unecessary step (which takes up space), when I could just export the query.

Okay, I know there are disadvantages and negative connotations regarding
using Access macros. But forget about them, at least for this thread. Rag on
me later. lol, or not, whatever.

My antiquated upload process includes running this make-table query as the
last step in a macro [OpenQuery]. I don't want to make a table anymore. I
want to export directly from the query.

How can I amend my process? Is it possible to automate an export? VBA (which
I honestly don't know)?

Jarrod