Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister
 
PerlMonks  

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


Description:

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,
ant

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!
  • 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
  • Outside of code tags, you may need to use entities for some characters:
            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?
    Username:
    Password:

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

    How do I use this? | Other CB clients
    Other Users?
    Others about the Monastery: (8)
    As of 2014-08-29 20:49 GMT
    Sections?
    Information?
    Find Nodes?
    Leftovers?
      Voting Booth?

      The best computer themed movie is:











      Results (289 votes), past polls