Data Extraction with Code

B

Bluesman

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?
 
J

John Vinson

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]
 
Top