Create a txt file from access

[Simon]

I have a access database on a form i have have one customer details
( Name and address)
I would like a button on the form that when i click it it will create
a txt file and save it to C:\CusomerDetails.txt

I would like the txt file to look like following

Mr, John, Smith, 45 Queen Street, London, NW3 8LP


as i will be writing over this file a lot it does not need to ask me
to save or over write this file each time


Any help would be great

Thanks

SImon

 

[Douglas J. Steele]

Take a look at the TransferText method in the Help file.

 

[IT-1957]

The text.file can be created using a macro,

macros
new
transfertext

Now, the data for your text file has to come from some where, a table or a
query, youll have to create that befoure you can create a text file using thi
method.
On the propetirs seccion select the source, name, destination, etc.