Data Tools only work for Windows XP. Click Here for a solution

DataTools to Migrate Data from MS Access to MySQL

Jul 28

Written by:
7/28/2011 7:53 AM  RssIcon

Pervasive DataTools has the right tool for migrating data from Microsoft Access to MySQL - without writing code.

The Data UpLoader to MySQL connects to your source-side MS Access database directly and to your target-side MySQL database via ODBC. Easily create each new table in your MySQL database by simply dragging and dropping the ""All Fields"" icon in the Map Fields interface. Make any needed changes to field names, data types, and/or data field sizes in the same window.

Here are just SOME of the features of the Data UpLoader to MySQL that make migration from MS Access to MySQL a snap:

  • Read MS Access data and table schema from single tables or views, or write SQL statements to join data from multiple source tables.
  • Automatic detection and resolution of data type differences between Access and MySQL.
  • Built-in Expression Builder for writing expressions to clean and transform dirty data on the fly.
  • Test Control Panel for testing your field mapping and expressions. View the results in the Data UpLoader to MySQL user interface, make needed changes, and get it right before writing any records to MySQL.

The Data UpLoader to MySQL is available FREE for a limited time. Simply register on the Pervasive DataTools web site, download the Data UpLoader to MySQL and start migrating your data from MS Access to MySQL today!

- The Pervasive DataTools Team

Tags:
Categories:

Your name:
Gravatar Preview
Your email:
(Optional) Email used only to show Gravatar.
Your website:
Title:
Comment:
Security Code
CAPTCHA image
Enter the code shown above in the box below
Add Comment   Cancel 

Recent Posts

DataTools HowTo: Solve an ""Overflow (6)"" Error
DataTools HowTo: Manually Parse a C-ISAM Data File
DataTools HowTo: Manually Parse a Btrieve Data File
DataTools HowTo: Manually Parse a Binary Data File
DataTools HowTo: Standardize Various Date Formats
DataTools HowTo: Resolve Btrieve Error 161
DataTools HowTo: Find DataTools Error Codes
DataTools HowTo: Resolve a Simulated Spoke Error
DataTools HowTo: Handle Multi-line Address Data
DataTools HowTo: Resolve Target Field Name Errors
DataTools HowTo: Resolve Installation Problems
Pervasive Data Inspectors Released!
DataTools v9 is Released!
DataTools is Transitioned from v8 to v9
DataTools to Migrate Data from Informix
DataTools to Parse Btrieve Data
DataTools to Convert Text to Date
DataTools to Parse a Binary Data File
DataTools to Migrate Data from MySQL to PostgreSQL
DataTools to Migrate Data from MS Access to MySQL
DataTools Solutions for Data Conversion Projects
DataTools to Parse Fixed Text Data
DataTools to Load Data into IBM DB2
DataTools to Parse Legacy COBOL Data
DataTools for Amazon.com Store
DataTools for eBay Store
DataTools for SugarCRM
Import Data into GMail Contacts
DataTools to View Data
DataTools to Load Data into PostgreSQL
DataTools to Load Data into SQL Server
DataTools for MySQL
DataTools to Load Data into Oracle Database
DataTools to Extract Data from Print Files
DataTools to Load Data into Salesforce.com
DataTools to Parse C-ISAM Data
Data Joiners Join Heterogeneous Data
Announcing New DataTools UpLoaders and DownLoaders
Announcing the Release of Pervasive Data Builders
New Pervasive DataTools Products Coming Soon!
DataTools to Migrate Data from SQL Server to MySQL
DataTools for ACT to SugarCRM Migration
DataTools for Goldmine to SugarCRM Migration
Welcome to the Pervasive DataTools Community!

Blog Admin Panel

You must be logged in and have permission to create or edit a blog.