Schedule to Export Data

[Guest]

Can i export data out of local access database and copy the data to a FTP
location on a website?, how can i do that?. This need to happen on daily
basis, can I schedule a job?

 

[Guest]

I got this from a previous post. I hope it helps

"As far as I know Access doesn't recognises the ftp or http protocols, so
you have to download the database file to a local or LAN drive. These
links may help:

http://www.mvps.org/access/modules/mdl0015.htm
http://www.mvps.org/access/modules/mdl0037.htm

For more information, try searching http://groups.google.com for

access ftp link group:microsoft.public.access.*"

 

[Guest]

you can use microsoft Scheduler to start up Access when you want and then
just write some vb to copy it down to the shared folder ..