Export to .bat file

[Ripper]

I need to export a list of names to a .bat file so that I can create folders.
I created the query to get the names out, but when I export using SendObject
there are text lines all around my names. I cannot then rename it to make
the .bat file.

Is there a way to export to a text file from a query or table that will not
draw the lines for me?

 

[Roger Carlson]

You could export it using the TransferText method. Easiest way to create it
is to make a macro that uses the TransferText action, add the values you
want, then (after saving the macro) convert the macro to code with the
SaveAs Module option. Then you'll have the VBA code for the TransferText
method.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L