Export Access data to spreadsheet online.

[Mark]

Hi, im looking for a solution to a project. I want to
take our online data thats in Access, and export it to a
spreadsheet that will be downloaded by whoever i give
permission to do so.

Is there a query taht i can use that will send the data
to a downloadable spreadsheet?

Thanks in advance

 

[Tom Gahagan]

Hi Mark....

Unless you use com services (and even then I'm not "certain" you can do it?)
you will not be able to do this "online". A lot of hosting companies will
not allow this type of transactions on their servers.

You could, however, do the conversion on your local machine, and then simply
import the spreadsheet files to the web and provide a download link to the
files. Perhaps a little more work than you want but it would get it done.

Best to you....
Tom Gahagan
eThomaston.com