There might be a better way but here's a suggestion: When I needed to switch from an Access db to mysql I couldn't find any docs about exporting the table structures from Access to mysql, so I documented the Access db and manually built the same table structures in mysql. Then export the Access data as comma delimited files and import them into mysql. If you want to do this on a regular basis you could set a schedule(either human or with crontab) to periodically export the Access contents and reload the mysql tables.
Andrew Hazen -----Original Message----- From: Mark Stringham [mailto:[EMAIL PROTECTED]] Sent: Friday, March 22, 2002 3:11 AM To: MySQL Subject: MySQL, MyODBC and MS Access I have a project where I may need to connect an MS ACCESS db and MySQL. I have read some pretty good documentation and know that is possible to take an existing Access db and export it to MYSQL. I have a few questions and wondered if someone might offer some insight. 1. Where must the Access db reside in order to talk with MySQL? 2. After the import to MySQL, if I insert new data into MySQL will the Access db be updated as well? I am looking for a way to access live MS Access data from the web. Obviously, I could connect directly to the Access db itself but with limited connections, I would think it would be hard to share the data . My thought was when someone updated the Access db, the data is then exported to MySQL. I then could use php, JSP or whatever to access the data from the web without having to worry about odbc connections. Am I way off here? Any help is appreciated. thanks Mark --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
