|
|
Posted by Rory Browne on 04/01/05 03:40
I don't think it's a case of 'finding a way'. I think its a case of
writing some code.
Some pseudo code to get you started:
connect_to_mysql();
$ms_Access_handler = use_com_ole_or_odbc_to_open_an_access_db();
while( $row = get_row_from_mysql() ){
$ms_Access_handler->insert_row($row);
}
$ms_Access_handler->save_db("filename.mdb");
Just a thought.
On Thu, 31 Mar 2005 12:36:51 -0700, René Fournier <m5@renefournier.com> wrote:
> 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
> >
> >
> >
> >
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
[Back to original message]
|