Sr. Web Developer
mediabistro.com
US-NY-New York

Justtechjobs.com Post A Job | Post A Resume

How to Import Excel, Access or XML Data into MySQL Using Navicat
Tutorial on Import/Export Wizard of Navicat
Import Data to Table Using Import Wizard
  1. Click the Tables tab
  2. If you have an existing table to which you want to import data, select the table. Otherwise, do not select any table.
  3. Click Import Wizard at the Database Window
    OR
    Right-click anywhere in the Database Window and select Import Wizard
  4. An Import Wizard dialog box will be shown
  5. Depending on the import data format, you should follow several steps to complete the import process. Here are the steps for importing from text file:
Import Wizard Steps:
  1. State which import data format you would like.
  2. Locate your file for import data.
  3. Select the appropriate delimiter. (For text file only)
  4. You can define some additional options for source.
  5. The wizard has made some guesses about where your field breaks occur. If they are incorrect, you can make adjustments in this step.
    NOTE: If the import data format is Text format and you have selected "Fixed width" in step 3, you can set field breaks in this step.
  6. The wizard will make some guesses on your table structure and you can make adjustments.
  7. You can define the field mappings. Set Mappings to specify the correspondence between fields in the Source and fields in the Destination.
  8. Check your data before importing.
  9. Select a desired import mode.
  10. Click Execute button to start importing data.
[ Next Page ]

[Page 1]  [Page 2]  


Comments:
RE: import Excel files in to Mysql using PHPsrinivas02/12/06 23:46
RE: import Excel files in to Mysql using PHPhow to import excel file in mysql using php06/08/05 12:10
Desarrollo Aplicaciones Php.Felipe Qp.03/11/05 09:17
import Excel files in to Mysql using PHPVishal03/11/05 01:06
XML to Mysql data conversionAmrita03/07/05 05:40
help with converting excel to accesshelp03/06/05 20:23
RE: Javascript with PHPsriram Goteti03/05/05 12:53
import from .xls file to mysqlankur02/16/05 12:15
RE: Javascript with PHPorpad01/30/05 04:14
Cannot Extract Username & PasswordJacky04/03/04 05:44
RE: Javascript with PHPMic02/25/04 14:03
RE: Javascript with PHPMichal02/11/04 19:37
Javascript with PHPRohan Lopes01/30/04 05:48
 

If you are looking for help, please post on the appropriate forum here. Your questions will be answered much more quickly.

Add A Comment:

Name:

Email:

Subject:

Message:

To reduce spam posts, messages are now manually approved

You are not [logged in]. That means your account will not get credit for this post.