Re: Converting Databases

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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
frontend.

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!


Marco
-- 
------------
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:
> Hi,
> 
> 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 peter@inneroptics.com
> 
> 
> -- 
> 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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux