Solved

Uploading Access database to MySQL - issues?

Posted on 2015-02-20
5
236 Views
Last Modified: 2015-03-06
I've been asked for help with uploading an Access database into a MySQL database...I haven't done this before..what should I watch out for? Any recommended tutorials...
0
Comment
Question by:agwalsh
5 Comments
 
LVL 83

Assisted Solution

by:Dave Baldwin
Dave Baldwin earned 167 total points
ID: 40620763
0
 
LVL 84

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 166 total points
ID: 40620855
I've used these:

http://www.convert-in.com/

Best $39 (or $99, depending on which you need) you'll spend for moving data from Access to MySQL.
0
 
LVL 18

Accepted Solution

by:
Simon earned 167 total points
ID: 40621122
And here a a couple of links that compare the datatypes available in Acess v MySQL:
http://www.htmlcenter.com/blog/ms-access-and-mysql/
http://www.seattlecentral.edu/~cstanford/itc220/datatypes.pdf
0
 

Author Closing Comment

by:agwalsh
ID: 40648877
Thank you all for that :-)
0
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 40648888
You're welcome!
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question