If anybody remembers from a previous post, I was trying to find a easy way to export my ms access data to mysql database. Last time it seemed that the easiest way would be to convert the access tables into a comma delimated text file and then import it back into mysql with a programming language like php. But this is just plain clumsy on the face of it. I had been looking for a easier way since. And looks like I finally found how to do just what I need. Export an ms access database to mysql over the internet directly, without any hassle. Meet the Navicat!
| Quote: |
Navicat can convert Excel spreadsheets/MS Access data to MySQL databases, eliminating time-consuming data entry and the errors that accompany it. It uses a Microsoft Access-like interface and comes with a MySQL server launcher and comprehensive manual that will help you get started. Navicat is more than just a simple MySQL admin client - other useful features include scheduled backup, data transfer, import/export wizard, support for Foreign Keys, visual query builder, and visual report builder.
Navicat's Database Transfer Tool is a visual data transfer tool designed for developers who work between different MySQL servers or need to move databases between two MySQL servers. |
The features of navicat
| Quote: |
SSH Tunnel - New!
support importing data from ODBC - New!
support editing text in Blob field - New!
support to print table structure - New!
support to create schedule for Import/Export, Data Transfer and saved queries. (similar as schedule backup feature) - New!
support to create Report Archive from command line - New!
support MySQL 4.1.x and MySQL 5.0 Alpha (support stored procedure)
Support Multiple Connections for local or remote MySQL servers
Browse your databases
Create and delete databases, tables, indexes and users
Modify your data
Create or Run SQL queries with visual query builder
Create reports with visual report builder
Report Archive Feature - Reports can be saved as an archive file (.raf) for backup and increased portability.
Manage user privileges [security configuration]
Backup/Restore your database
Import/Export data ( It supports up to 18 most popular formats including MS Access, MS Excel, XML, PDF and TXT. )
Schedule Backup - The new Schedule Backup feature is used to create a new schedule that will backup your data.
Data Transfer - Support transfer databases from one MySQL server to another MySQL server (1. Local to Remote , 2. Remote to Remote, 3. Remote to Local) create Schedule for Import/Export wizard create Schedule for Saved Queries
Foreign Keys - Support to configure Foreign Keys
Unicode Support |
How easy it is to use Navicat to export your access table to a remote server host mysql?
To export data using the Export Wizard:
| Quote: |
Click the tables tab.
Select the table that you want to export data from. Click Export Wizard at the database window, or, right-click anywhere in the database window and select Export Wizard.
An Export Wizard dialog box will be shown.
Select which data format you want and click OK button to proceed. |
All that and more. Download Navicat from here:
Navicat home website
http://www.mysqlstudio.com/detail.php3
_________________
Dust fills my eyes / Clouds roll by / and I roll with them / Centuries cry / Orders fly / and I fall again
Afford best design, implement best solution. Outsource your web design.
