Re: php and databases

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