Exporting a Query to a Delimited Format

  • Thread starter Thread starter David
  • Start date Start date
D

David

I am trying to export a query to a text file when a user clicks a button.
Is there a way, using the TransferText function, to export a query to a
given path, with a
delimited format? I am looking to manipulate the file to get no delimiter
characters or "" marks to match a customer specified format. Something
like:

FiledX FieldYHJYYU FieldHJY FieldIOIO

Is this possible?

Thank you very much.
 
David,

Run throught the export manually, via the File|SaveAs/Export menu. In
the last screen of the wizard, click the Advanced button, and save
your setup with a specification name. Then use this in the
Specification Name argument of your TransferText macro.

- Steve Schapel, Microsoft Access MVP
 
Steve
I am wanting to do the same thing as David, but I can't seem to get the specification wizard. I select "files", "export", then I select text as file type. Shouldn't the specification wizard appear, to allow me to modify my output? I just get a normal save screen, and it saves it to a file.
Do you have any ideas on what I can do to get to the specification wizard?
 
Back
Top