Import data using import wizard
- In the Database Window , click the
Table tab.
- If you have an existing table to which you want to import
data, select the table. Otherwise, do not select any table.
- Select Import Wizard from the table menu.
- An Import Wizard dialog box will be shown.
- Currently, Navicat supports importing DBF, TXT, HTML,
Lotus 1-2-3 and XML. Here are the steps for importing a
file:
Steps:
Step 1. State which import data format you would like.
Step 2. Locate your file for import data.
Step 3. Select the appropriate delimiter. (For text file
only)
Step 4. You can define some additional options for source
Step 5. Select the target table
Step 6. The wizard will make some guesses on your table structure
and you can make adjustments.
Step 7. Select a desired import mode. If you are importing
the file as a new table(s) or you do not define the primary
key in Step 6 of the wizard, you will only have 2 options
here.
Step 8. Click Start to run the import immediately or Save
to save it as an Import Profile for creating a Schedule Task.
Please visit Working with Schedule
for details
Running Navicat's Import from the
command line
- From the command line start Navicat using the following
options
./start-navicat
--import
ConnectionName
DatabaseName
ImportFileName
Replace ConnectionName with the
name of the your connection. Replace DatabaseName
with the name of the your database. Replace ImportFileName
with the name of the saved Import Profile.
Export data by using Export Wizard
- In the Database Window , click the
Table tab.
- Select the table which you want to export data. Select
Export Wizard from the table menu.
- An Export Wizard dialog box will be shown.
- Select which data format you want and click OK button
to proceed. Also, Navicat supports exporting DBF, TXT, HTML,
Lotus 1-2-3 and XML. Here are the steps for exporting a
file:
Steps:
Step 1. State which export data format you would like.
Step 2. Choose the table fields you wish to export.
Step 3. Select the appropriate delimiter and ocate your file
for export data.(For text file only)
Step 4. Click Start to run the export immediately or Save
to save it as an Export Profile for creating a Schedule Task.
Please visit Working with Schedule
for details
Running Navicat's Export from the
command line
- From the command line start Navicat using the following
options
./start-navicat
--export ConnectionName
DatabaseName
ExportFileName
Replace ConnectionName with the
name of the your connection. Replace DatabaseName
with the name of the your database. Replace ExportFileName
with the name of the saved Export Profile.
|
