Using Macro to Export Text to Notepad

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

Guest

I am trying to run a macro that exports text from a query to notepad, this
works, but Access attempts to put a frame around each result, I need raw text.

See below - Can you help?

-Mark Matzke

I need the result in notpad to be:

1a234567
2a987654
3b543210

I get something like this:
 
I am note sure how to do that, tried every option - here is how it is currently

Macro: OutputTo

Object Name FTP File
Output Format MS-DOS Text
Aoutput File c:\Locate.txt
Auto Start No
Template File
 
Thank you for help on this - This is what worked:

If you don't want the quotes around the values, I don't think you can
use the delimited format. So you'll need to use fixed width output, and
that means you'll need to create an export specification. To do that,
export the query once manually to a text file, and choose Fixed Width
output in the Export Text Wizard. Set up the column widths the way you
want, and when you get to the point in the Export Text Wizard where
everything is specified and you're ready to finish and export the file,
click the Advanced... button to review the specification, and then click
the Save As... button on that dialog and save it with a meaningful name.
Once you've saved the specification, you don't even have to finish the
export.

Go back to your macro, and enter the name of that specification in the
macro's "Specification Name" argument.
 
Mark,

Pleased to see that you've got a working solution. However...

If you don't want the quotes around the values, I don't think you can
use the delimited format.
Click to expand...

.... this is not correct, you can certainly export to a delimited text
file without the "" qualifiers.
 
Back
Top