Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation

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

( #17804=categorized question: print w/ replies, xml ) Need Help??
Contributed by mosiondz on Jun 13, 2000 at 02:55 UTC
Q&A  > 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.

Answer: How do I transfer information from a MySQL DB to an Access DB?
contributed by antjock

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,

Answer: How do I transfer information from a mySQL DB to an Access DB?
contributed by btrott

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.

Answer: How do I transfer information from a MySQL DB to an Access DB?
contributed by QandAEditors

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.

Answer: How do I transfer information from a MySQL DB to an Access DB?
contributed by vaevictus

Or, don't use perl, and just open up access with an ODBC driver and access the data directly from access....

Please (register and) log in if you wish to add an answer

  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.
  • Log In?

    What's my password?
    Create A New User
    and the web crawler heard nothing...

    How do I use this? | Other CB clients
    Other Users?
    Others perusing the Monastery: (15)
    As of 2015-11-25 20:39 GMT
    Find Nodes?
      Voting Booth?

      What would be the most significant thing to happen if a rope (or wire) tied the Earth and the Moon together?

      Results (690 votes), past polls