Re: Re: Create MDB File
| From: | René Fournier | Date: | Thu, 31 Mar 2005 19:36:51 +0000 |
| Subject: | Re: Re: Create MDB File | ||
| References: | 1 2 3 4 5 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-211975@lists.php.net to get a copy of this message | ||
Coincidentally, I also need a way to read a table from MySQL and write it out to an .MDB file on-the-fly (from within a PHP script).
The CSV export idea isn't an option in this case.
Has anyone found a way to create an MDB file (with a single table) from PHP?
...Rene
On 28-Mar-05, at 7:18 PM, Rory Browne wrote:
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@hotmail.com> 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@hanez.org> wrote in message news:200503282255.26459.mailman@hanez.org...-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.phpSorry, 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 sotherei 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-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.phpis only one company which delivers this software. Regards Johannes On Monday 28 March 2005 22:08, Shaun wrote:-- # Johannes FindeisenHi, 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