hello mark, been doing this quite a bit recently but i cheat a bit...
1st step is to export the table from access as a text file - delimited by comma's. if you load up phpMyAdmin (available at http://www.phpwizard.net/projects/phpMyAdmin/), create your database and then mimic the table set up from access, you can then use the 'Insert textfiles into table' function to load all the information. a bit time consuming but it does work! phpMyAdmin is wicked as well.... hope this helps, jake > > > 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
