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 3 of 3

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

  1. #1
    Forum VIP
    Join Date
    Jul 2010
    Posts
    1,777
    Thanks
    25
    Thanked 348 Times in 323 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,431
    Thanks
    191
    Thanked 844 Times in 786 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.

  3. #3
    Junior Member
    Join Date
    Jan 2015
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

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

    Quote Originally Posted by copeg View Post
    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: 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.
    As a forum moderator, you should be ASHAMED with this kind of response, sir. It's a thinly veiled insult of suggesting "lmgtfy" Then you provide the most basic instructions for troubleshooting, suggesting the OP has cognitive difficulties when it comes to figuring out how to solve the most basic problems. It is NO WONDER the OP didn't repost, you have not only scared him/her away from your forum, but Java as well. We must be more open to the community. I request that you resign your position as administrator IMMEDIATELY.

Similar Threads

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