Data Extraction with Code

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am looking for a "canned" means to export my query as a text file.
I would like to place this on a button.
Does anyone have the code snippets for this?
Can someone send me in thr ight direction for info?
 
I am looking for a "canned" means to export my query as a text file.
I would like to place this on a button.
Does anyone have the code snippets for this?
Can someone send me in thr ight direction for info?
Click to expand...

Take a look at the VBA help for "TransferText". This should be a
one-liner in the button's Click event.

John W. Vinson[MVP]
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I migrate MBOX to PST? 2
Extracting source code 2
Can Linux extract data from .MDB file, and output to text ? 1
Doing away with quotes in export file 8
Different ways to extract data from Access to Excel 2
Extract Headers from Crosstab query 2
Auto Export Query 1
Help with code interpretation 4

Back
Top