How export data from Access ?

[gazolba]

I have a database that will become an MDE and hopefully the back end will be secured. But the users need access to the data for speadsheets etc. How can I provide an export facility? Access seems to have ways to import data but not export it?
- David

 

[dhaveedh]

What output format do you require? You can export in various file formats like HTML, TXT, RTF, XLS in access.
You can use:

docmd.transfertext but you need to specify the output format

KISS - Keep It Simple Sugar!