specific extention

[serge]

Hello,

Would like to export a table to my C: but with a specific extention such as
..reu or .pts. (which could be read by another system). However, the file
would be as a CSV file format. How do I do that with Transfertext (I guess) ?

Thanks in advance,
Serge

 

[Roger Carlson]

Well, one way would be to rename the file after it has been exported. To do
that, follow your TransferText command with a Name command:

Name "C:\query2.csv" As "C:\query2.reu"


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