Export table contents into CSV?

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

Guest

I posted a similar question in another area a few days ago but got no
response. Hopefully "General Questions" reaches a wider audience, as I'm sure
somebody must have the answer!
I will be generating sales invoices from my app and storing all the details
in a single table.
I need to export this data in a csv file which can then be passed to the
accounting system for import into the sales ledger. (I have their spec for
the data formats etc, no issues there).
How do I go about this? I would like to make it as seamless as possible so
that one of the regular users could do it at the end of each day, ideally
just by clicking on a button or two.
As a nicety, the process should include a flag for each invoice that says
whether it has been exported yet or not, so that it will only be passed to
the accounting system just once.
Thanks in advance for all the suggestions!
CW
 
CW,

Check out the TransferText method of the Docmd object to achieve what you
are looking for.

Alastair MacFarlane
 
Back
Top