Query output to text file

  • Thread starter Thread starter Greg Bruntzel
  • Start date Start date
G

Greg Bruntzel

Hi,

I am running a simple query on a table to pull out records for specified
dates. However, I need to send the output to a delimited text file. This
is done easily enough using the Access menus/interface, but I'd like to code
this so the user only has to enter dates for the records they need.

The fields will have no text delimiters, and the field delimiters are tildes
(~). Of course the record delimiters are CRLF.

Greatly appreciate any help if someone has done this before.

Thanks,
Greg
 
Greg said:
Hi,

I am running a simple query on a table to pull out records for specified
dates. However, I need to send the output to a delimited text file. This
is done easily enough using the Access menus/interface, but I'd like to code
this so the user only has to enter dates for the records they need.

The fields will have no text delimiters, and the field delimiters are tildes
(~). Of course the record delimiters are CRLF.

Greatly appreciate any help if someone has done this before.

Thanks,
Greg
Click to expand...

You need:

Export specification.
TransferText method of the DoCmd object.

See Access help articles on both.
 
Back
Top