Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses
 
PerlMonks  

How do I transfer information from a MySQL DB to an Access DB?

by mosiondz (Acolyte)
on Jun 13, 2000 at 02:55 UTC ( #17804=perlquestion: print w/replies, xml ) Need Help??

mosiondz has asked for the wisdom of the Perl Monks concerning the following question: (database programming)

I am attempting write a function to transfer information from a mySQL database on a Unix-based system to an Access database on an NT-based system. What is the best way to go about this problem?

I had thought about having an ActiveState Perl script on the NT server receive information from an HTTP call from the Unix system, and then put that information into the database, but I was wondering if there was a better way to go about this, perhaps by connecting directly to the Access database in some way.

Originally posted as a Categorized Question.

  • Comment on How do I transfer information from a MySQL DB to an Access DB?

Replies are listed 'Best First'.
Re: How do I transfer information from a MySQL DB to an Access DB?
by antjock (Novice) on Jan 17, 2001 at 02:50 UTC

    Just install the MyODBC driver on your winders machine.

    It's pretty easy to install and get up and running. I have set this up in the past for clients who have mysql databases on a webserver, but want to see and manipulate the data on their winduhs machine in Access.

    hope that helps,
    ant

Re: How do I transfer information from a mySQL DB to an Access DB?
by btrott (Parson) on Jun 13, 2000 at 04:06 UTC
    Try using DBI. You could use DBD::MySQL to connect to the MySQL db, then use DBD::ODBC (I think) to connect to the Access db. Then you can select from one database handle and insert into the other.
Re: How do I transfer information from a MySQL DB to an Access DB?
by Anonymous Monk on Jun 30, 2000 at 05:16 UTC
    Take a look at DBIx::Copy. You pass it two database handles and tell it which tables you want to copy. It doesn't have facilities for recreating table structure, though, so you'll need to use DB-specific commands (either from command-line tools or DBI) to create the tables first.
Re: How do I transfer information from a MySQL DB to an Access DB?
by vaevictus (Pilgrim) on Jan 16, 2001 at 23:45 UTC
    Or, don't use perl, and just open up access with an ODBC driver and access the data directly from access....

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: perlquestion [id://17804]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others chanting in the Monastery: (3)
As of 2022-05-24 20:57 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Do you prefer to work remotely?



    Results (84 votes). Check out past polls.

    Notices?