MDB suggests Access, so why not simply create a CSV, or some other generic format file from your MySQL, and import it into access, using COM/OLE, and save it as an MDB file. On Mon, 28 Mar 2005 22:14:07 +0100, Shaun <shaunthornburgh@xxxxxxxxxxx> wrote: > Thanks for your reply, > > but this only works on Windows. I need a program that will create an MDB > file on the fly from a query on the MySQL database... > > > "Johannes Findeisen" <mailman@xxxxxxxxx> wrote in message > news:200503282255.26459.mailman@xxxxxxxxxxxx > > Sorry, > > > > i forgot that link: > > > > http://www.convert-in.com/sql2acc.htm > > > > > > On Monday 28 March 2005 22:46, Johannes Findeisen wrote: > >> Hello, > >> > >> i had the same problem some years ago. At this time i have set up all > >> tables in Access and wrote a script which reads from MySQL and inserts > >> into > >> the MDB file via the ODBC connector. This works but is much work when > >> your > >> database is very big. > >> > >> 2 Years ago i had the same problem but it must go as fast as possible so > > >> i > >> decided to buy a converteer since i didn't find anything free. They are > >> working very good. I don't know where i have buyed them but i think > there > >> is only one company which delivers this software. > >> > >> Regards > >> Johannes > >> > >> On Monday 28 March 2005 22:08, Shaun wrote: > >> > Hi, > >> > > >> > Does anyone know if its possible to create an MDB file from a Mysql > >> > database using a PHP script, I have only managed to find Access to > >> > Mysql > >> > conversion programs so far... > >> > > >> > Thanks for your help > >> > >> -- > >> # Johannes Findeisen > > > > -- > > # Johannes Findeisen > > -- > 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
