I assume that you could write a macro that would run the query on a daily or hourly basis or something.
If you're not able to create an ODBC link to the mySQL database, then there will most likely be some manual intervention. It would not be hard to procedure-ize and mostly automate the export and import process, though (with a little help from their ISP). (I'm assuming that they have an ISP that is hosting the box, if they're not hosting the box locally. If they were hosting it locally, they'd most likely be able to create an ODBC connection to it.)
So the short answer is: "Yes, you can, but if you have to ask, (or if most of what I've written so far went over your head), you'll probably want to get some help doing it."
-Cameron Wilhelm
On Thursday, July 31, 2003, at 04:41 PM, Voodoo wrote:
I'm building an integrated system with Access and mySQL. Some company has na internal system based on Access and a web site with a form that saves its variables in a mySQL db. Can I make a system that migrates automatically the data from the mySQL online db for the the local Access db? And how? Can somebody help me?
Thanks for now
Cheers
Voodoo
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
