MS Access ODBC Driver

[Jeff]

I need to export MySQL data to Access.

As always, there seems to be more than one way to do this.

I notice that PHP has: DB.php

If I was doing this in perl, there would be an ODBC driver
(DBD::ODBC). Is there such a thing in PHP? Can this play well with DBO?

I see some commercial driver products, but my needs are modest as I'm
not using any of Accesses special features, whatever those might be!

Jeff

[Richard]

----- Original Message -----
From: "Jeff" <jeff@spam_me_n ot.com>
Newsgroups: comp.lang.php
Sent: Saturday, August 23, 2008 5:18 PM
Subject: MS Access ODBC Driver

I need to export MySQL data to Access.

As always, there seems to be more than one way to do this.

I notice that PHP has: DB.php

If I was doing this in perl, there would be an ODBC driver
(DBD::ODBC). Is there such a thing in PHP? Can this play well with
DBO?

I see some commercial driver products, but my needs are modest as
I'm not using any of Accesses special features, whatever those might
be!

Jeff

Hi,

can you not just install / use the PHP ODBC ?
http://nl2.php.net/odbc

I have used that with succes.
For a one time transfer you might get away with a csv export mentioned
in
this thread, but then you have to create an import specification in
Access,
since the csv file does not contain any database / field information.

Richard

[Jeff]

Richard wrote:

----- Original Message -----
From: "Jeff" <jeff@spam_me_n ot.com>
Newsgroups: comp.lang.php
Sent: Saturday, August 23, 2008 5:18 PM
Subject: MS Access ODBC Driver

> I need to export MySQL data to Access.

As always, there seems to be more than one way to do this.

I notice that PHP has: DB.php

If I was doing this in perl, there would be an ODBC driver
(DBD::ODBC). Is there such a thing in PHP? Can this play well with
DBO?

I see some commercial driver products, but my needs are modest as
I'm not using any of Accesses special features, whatever those might
be!

Jeff

Hi,

can you not just install / use the PHP ODBC ?
http://nl2.php.net/odbc

I have used that with succes.

This looks good. The install notes are very sketchy and I'm
relatively new to php. Is this "installed" when php is compiled?

For a one time transfer you might get away with a csv export mentioned
in
this thread, but then you have to create an import specification in
Access,
since the csv file does not contain any database / field information.

Thanks, I suspected that. There's several users who will need to
"download" and periodically run reports. The whole thing died when they
got moved from one Verio Server to another. I've heard people say nice
things about Verio but I chalk that up to inexperience with them!

Jeff

>
Richard

[C. (http://symcbean.blogspot.com/)]

On 23 Aug, 16:56, Michael Vilain <vil...@NOspamc op.netwrote:

In article <8cWdnZ0uWcbRty 3VnZ2dnUVZ_uKdn ...@earthlink.c om>,

*Jeff <jeff@spam_me_n ot.comwrote:

* *I need to export MySQL data to Access.

* *As always, there seems to be more than one way to do this.

* *I notice that PHP has: DB.php

* *If I was doing this in perl, there would be an ODBC driver
(DBD::ODBC). Is there such a thing in PHP? Can this play well with DBO?

* I see some commercial driver products, but my needs are modest as I'm
not using any of Accesses special features, whatever those might be!

* *Jeff

Why ever would you want to do that?

If you must, then export the MySQL tables over ODBC and map them in
Access. But you'll probably need to set all your queries to run as
passthru to get decent performance.

>
Why not use phpMyAdmin and export to a CSV file? *AFAIK, Access can read
that just fine. *I see no need to output directly to Access. *Use an
intermediate file.

Why not just export it as SQL commands - then you just paste the SQL
to create the table.

C.

[Richard]

"Jeff" <jeff@spam_me_n ot.comwrote in message
news:5K******** *************** *******@earthli nk.com...

Richard wrote:

>----- Original Message -----
From: "Jeff" <jeff@spam_me_n ot.com>
Newsgroups: comp.lang.php
Sent: Saturday, August 23, 2008 5:18 PM
Subject: MS Access ODBC Driver

>> I need to export MySQL data to Access.

As always, there seems to be more than one way to do this.

I notice that PHP has: DB.php

If I was doing this in perl, there would be an ODBC driver
(DBD::ODBC) . Is there such a thing in PHP? Can this play well with
DBO?

I see some commercial driver products, but my needs are modest as
I'm not using any of Accesses special features, whatever those
might be!

Jeff

Hi,

can you not just install / use the PHP ODBC ?
http://nl2.php.net/odbc

I have used that with succes.

This looks good. The install notes are very sketchy and I'm
relatively new to php. Is this "installed" when php is compiled?

Yes, as far as I remember I never installed anything extra.

>For a one time transfer you might get away with a csv export
mentioned in
this thread, but then you have to create an import specification in
Access,
since the csv file does not contain any database / field
information.

Thanks, I suspected that. There's several users who will need to
"download" and periodically run reports. The whole thing died when
they got moved from one Verio Server to another. I've heard people
say nice things about Verio but I chalk that up to inexperience with
them!

If your users are on Windows, another option would be to use the ODBC
driver for mySQL and use "linked tables" in Access.
Maybe you do not want this, because your users will have access to the
"live" data.
Maybe create a read-only / restricted user for the ODBC connection?

The ODBC connection from Access I have used many times too, and works,
although it has some quirks.

Richard