You are here: Re: [PHP] Re: Create MDB File « PHP « IT news, forums, messages
Re: [PHP] Re: Create MDB File

Posted by Ren� Fournier on 03/31/05 22:36

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...
>>> 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
>
>
>
>

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация