Re: [PHP] 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] php and databases
[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
Re: [PHP] php and databases
On Fri, 25 Oct 2002, Tyler Durdin wrote: >-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. What comes to mind first is letting them use their Access to access the MySQL tables directly through the MyODBC capabilities. It works pretty well, but will take some setup. This may prove to be the best way to "copy" an Access accessed MySQL toa native Access database. The only thing I can think of PHP helping you out here is by generating a good delimited file available for download which Access or Excel should be able to swallow whole. >- >-Bobby >- >- >- >- >- >-_ >-Surf the Web without missing calls! Get MSN Broadband. >-http://resourcecenter.msn.com/access/plans/freeactivation.asp >- >- >--- >-PHP General Mailing List (http://www.php.net/) >-To unsubscribe, visit: http://www.php.net/unsub.php >- ** John Huggins [EMAIL PROTECTED] http://www.phphosts.com/ ** -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php