Find the answer to your Linux question:
Results 1 to 3 of 3

Thread: MySQL > Access

Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1

    Question MySQL > Access


    Is there a way to convert a MySQL dump file to MS Access? I don't have access to the MySQL server, just the dump file. Otherwise some other reader program which displays the table layouts etc would be good.

    I've read that you can run an SQL query in Access somehow and do it that way. Not sure how.


  2. #2
    I am not familiar with myslqdumps, because plain exports give me all the control I need. However in Access, if you create a query, you can also see its SQL implementation: select New query, which will open up a graphical window in which you can click to create a bogus query (if you have already tables, else you need to create those too), then click SQL to see the underlying SQL. In your case it may not work however, because Access does not recognise the semicolon, so you cannot enter multiple queries. The least you can do is create the tables to see what the database looks like.
    An alternative is to use macros in Access which can do script calls, but that is out of scope of this forum.

  3. #3
    Linux Newbie
    Join Date
    Feb 2008
    Bangalore, India
    Registered Linux User: #476440

  4. $spacer_open

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts