Welcome to the Java Programming Forums


The professional, friendly Java community. 21,500 members and growing!


The Java Programming Forums are a community of Java programmers from all around the World. Our members have a wide range of skills and they all have one thing in common: A passion to learn and code Java. We invite beginner Java programmers right through to Java professionals to post here and share your knowledge. Become a part of the community, help others, expand your knowledge of Java and enjoy talking with like minded people. Registration is quick and best of all free. We look forward to meeting you.


>> REGISTER NOW TO START POSTING


Members have full access to the forums. Advertisements are removed for registered users.

Results 1 to 2 of 2

Thread: Converting Microsoft Database (.accdb) to SQL (.sql)

  1. #1
    Forum VIP
    Join Date
    Jul 2010
    Posts
    1,676
    Thanks
    25
    Thanked 329 Times in 305 Posts

    Default Converting Microsoft Database (.accdb) to SQL (.sql)

    I am wanting to convert my Access Database to a SQL Database and I wanted to know if anyone knew of any good, and free, programs that would do that.

    I'm not wanting to turn the Access Database into a SQL Database and create a server and all that crap for it. I'm simply wanting to create a .sql file that I can upload onto my website's import wizard.

    Any suggestions?
    NOTE TO NEW PEOPLE LOOKING FOR HELP ON FORUM:

    When asking for help, please follow these guidelines to receive better and more prompt help:
    1. Put your code in Java Tags. To do this, put [highlight=java] before your code and [/highlight] after your code.
    2. Give full details of errors and provide us with as much information about the situation as possible.
    3. Give us an example of what the output should look like when done correctly.

    Join the Airline Management Simulation Game to manage your own airline against other users in a virtual recreation of the United States Airline Industry. For more details, visit: http://airlinegame.orgfree.com/


  2. #2
    Administrator copeg's Avatar
    Join Date
    Oct 2009
    Location
    US
    Posts
    5,318
    Thanks
    181
    Thanked 833 Times in 772 Posts
    Blog Entries
    5

    Default Re: Converting Microsoft Database (.accdb) to SQL (.sql)

    Never had to convert between these two specific types, but have for others databases. In those cases I've used some free tools which facilitate the process. A quick google of "access to mysql" pulled up the following as well as a few others you might want to look into: Access To MySQL My recommendation would be to create a local test database that you can play with first, then when its wrinkle free upload to the production server.

Similar Threads

  1. Converting Hex to Decimal
    By r2ro_serolf in forum Java Theory & Questions
    Replies: 10
    Last Post: September 4th, 2011, 04:29 PM
  2. Retrieve from Microsoft Excel document for CodeGenerator?
    By lucienmontierre in forum JDBC & Databases
    Replies: 1
    Last Post: May 2nd, 2011, 02:19 PM
  3. Microsoft Office Communicator through java
    By balaji in forum Java Theory & Questions
    Replies: 1
    Last Post: September 22nd, 2010, 01:36 PM
  4. Replies: 6
    Last Post: August 30th, 2009, 04:31 AM
  5. Replies: 4
    Last Post: May 1st, 2009, 03:32 PM