	[x] Posted via EE Mobile
	Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.

Question

	[x] Attachment Details

Microsoft ACCESS to MySQL

Asked by drupal_100 in MySQL Server, Microsoft Access Database, Data Manipulation

Tags: Access MySQL

a very simple Microsoft Access (2007) database.
want to move it into MySQL.
What's the way to move it?

Currently need to manually create database in MySQL according to MS Access database,
then save the Access table as formatted text file, then use PHP program to process the
data and load them into MySQL.

Is there way to get database schema and data in SQL from MS Access (like reverse engineering), so can directly load it into MySQL?

View the Solution FREE for 30 Days

20091118-EE-VQP-93 - Hierarchy / EE_QW_3_20080625

Hall of Fame

1. pcelba22,870
2. mark_wills9,000
3. rrjegan178,200
4. mrjoltcola7,314
5. ushastry7,000
6. dportas6,050
7. sujith806,000
8. ozo5,500
9. BillBach5,400
10. mwvisa15,000
11. capricorn14,500
12. angelIII4,250
12. snoyes_jw4,250
12. earthman24,250
15. markgeer4,200
15. rockiroads4,200
17. sdstuber4,168
18. JestersGrind4,000
18. Zberteoc4,000
18. Sharath_...4,000
18. saurabh7264,000
22. LSMCons...3,700
23. schwertner3,500
23. momi_sa...3,500
25. ralmada3,200

1. angelIII28,450
2. pcelba22,870
3. mark_wills13,244
4. BillBach11,400
5. sujith8011,100
6. chapmandew10,500
7. dqmq10,230
8. sdstuber10,118
9. mwvisa19,900
10. dportas9,400
11. saurabh7269,250
12. ushastry9,000
13. grant3008,500
14. rrjegan178,200
15. BrandonG...7,800
16. mrjoltcola7,314
17. LSMCons...7,004
18. Sharath_...7,000
19. capricorn16,600
19. rockiroads6,600
21. momi_sa...6,500
22. ozo6,100
23. earthman25,600
24. Kdo4,700
25. jimpen4,625