Export MS Access to MySQL with SnapShots

Create a Database in Ms Access

Open Microsoft Access and Create/Open a database which you want to export.

Export Ms Access Table into Excel Format

After opening the database, create a table and populate the fields which you want to insert into mysql database

Import Excel File into MySql Database

Open the database in Mysql and click on export button. Select the excel file and select option export ms access to mysql  and click on Go Button

Best Related Posts are Following:

1. How do you parse and process HTML in PHP.
2. Edit an commit message in Github Repository - Commands.
3. How do you disable browser Autocomplete on web form field / input tag?.
4. Web Development Project Manager interview questions and answers.
5. How to create Dynamic XML Sitemap online.
6. What is UPnP in Skype?.
7. How to delete Content of File in windows.
8. Difference between SSL and HTTPS.
9. SPDY Protocol - Improve the Speed of web page.
10. Difference Between Hadoop and Big-Data.
11. Golden Rules for successful project.
12. Winners - Daily Habits of Successful People.
13. Export MS Access to MySQL with SnapShots.
14. Free Boost Web Application By 20% in Simple Steps.
15. What is Streaming Servers, Streaming Protocol and Port Protocol.
16. Google Dynamic Charts - Bar Pie and Line Chart - code snippets.
17. Web Technology Important Links - Create SiteMap - Monitor Website - SEO Health - All Google API - Blogspot Assistance links.
18. Domain Name Server.
19. Reduce the loading time of website.
20. Systems Development Life Cycle (SDLC).
21. Binary Search Tree.
22. Defination of SOLID DRY KISS UX.
23. Project Management Tips- Way to Successful project.
24. Design Patterns.
25. Rapid application development - Phase of RAD.
26. Waterfall model.
27. Agile Software Development - Principle of Agile Software Development - Agile means quick in movement..
28. Virtual Host Setup In Window System.
29. Convert worksheets into csv files.
30. Hadoop Interview Questions And Answers For Freshers.
31. PHP MAILER setting to send email through Gmail.
32. Validate Icalendar File or URL.

Convert worksheets into csv files

I would like to share a macro with you that convert multiple sheets into multiple csv file within on click.

For this you need MS OFFICE 1997 or Higher version and window system.

Following are the instructions for convert xls ito csv.

1) Open your xls file in ms excel.
2) Press (ALT+F8), a popup will open.
3) type a name like "ExportSheetsToCSV" and click on "create" button.
4) Now new window will open, delete all data and past following data.
Sub ExportSheetsToCSV()
Dim wSheet As Worksheet
Dim csvFile As String
For Each wSheet In Worksheets
On Error Resume Next
wSheet.Copy
csvFile = CurDir & "\" & wSheet.Name & ".csv"
ActiveWorkbook.SaveAs Filename:=csvFile, FileFormat:=xlCSV, CreateBackup:=True
ActiveWorkbook.Saved = True
ActiveWorkbook.Close
Next wSheet
End Sub

5) Now click on "Run" @ the top.
6) You can get all your csv files from the "c:\users\{username}\my documents\";

Best Related Posts are Following:

1. How do you parse and process HTML in PHP.
2. Edit an commit message in Github Repository - Commands.
3. How do you disable browser Autocomplete on web form field / input tag?.
4. Web Development Project Manager interview questions and answers.
5. How to create Dynamic XML Sitemap online.
6. What is UPnP in Skype?.
7. How to delete Content of File in windows.
8. Difference between SSL and HTTPS.
9. SPDY Protocol - Improve the Speed of web page.
10. Difference Between Hadoop and Big-Data.
11. Golden Rules for successful project.
12. Winners - Daily Habits of Successful People.
13. Export MS Access to MySQL with SnapShots.
14. Design Patterns.
15. Rapid application development - Phase of RAD.
16. Waterfall model.
17. Agile Software Development - Principle of Agile Software Development - Agile means quick in movement..
18. Virtual Host Setup In Window System.
19. Convert worksheets into csv files.
20. Hadoop Interview Questions And Answers For Freshers.
21. PHP MAILER setting to send email through Gmail.
22. Validate Icalendar File or URL.