Produce csv file with minimal interraction

[CW]

After we have produced invoices in our .mdb, they need to be exported to our
accounting system.
I have them saved in a table, and also in a query with just the fields that
the accounting system requires/accepts.
Now I need to export them to a csv file. I have tried using the Export
wizard but it requires confirmation of the format etc every time and requires
too much user input.
I would like to have a one-click button that simply collected the invoice
data from the query (or the source table, if it has to be that way) and
dropped it into a new csv file in a location of my choosing.
Can anybody help me with this please??
Many thanks
CW

 

[Jeanette Cunningham]

Hi CW,
Have a look at TransferText and TransferSpreadsheet. Help for these is
available from the code window.

Jeanette Cunningham

 

[CW]

Many thanks, Jeanette - it worked first time - great!
CW