Simple solution, if you only have one or two tables: dump them in comma
delimited format and then use the LOAD command from the MySQL shell
Alternative: use the MySQL ODBC component and export from access to that
(it works like a charm if you use the latest version).
Either way should make it quite easy.
Hope this helps!
php|architect - The magazine for PHP Professionals
The monthly worldwide magazine dedicated to PHP programmers
Come visit us at http://www.phparch.com!
On Sun, 2002-12-01 at 08:30, peter wrote:
> I am pretty much new to the field of php/mysql programming, however a future
> project of mine may involve the importing of a large database of products. I
> am expecting this database to be in MS Access form and am looking for
> solutions in advanced. Now the question, are there any methods for exporting
> from Access and importing to mysql (phpadmin front end). It has been a long
> while since I last used access, but the thought of using a macro to go
> through the results and out put them in a mysql argument form crossed my
> mind. Has anyone had a similar problem?
> I look forward to your reply.
> Peter [EMAIL PROTECTED]
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php