Or, more simply - set up an ODBC DSN on the Windows box to the MySQL database, and simply link the tables into Access.

Best regards,
Andrew Hill
Director of Technology Evangelism - OpenLink Software
Universal Data Access and the Virtuoso Universal Server
http://www.openlinksw.com/virtuoso/whatis.htm

On Friday, October 25, 2002, at 12:43 PM, Jay Blanchard wrote:

[snip]
Is there anyway to have php convert a database from mySQL to Access via a
webpage? I have a couple of people here who use Access to do mail merging
things with word and it would make my life a ton easier if I did not have to
convert the db's everytime they want the info. If anyone has any thoughts on
how to go about this it would be greatly appreciated. Thanks in advance.
[/snip]

Open and read the data via mysql_ ..() functions into an array. Then open an
ODBC connection to the acce$$ database and insert the data from the array.
Shouldn't be too hard.

HTH!

Jay



--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to