Data Import Overview

Data import is a process of converting data stored in one format into another.

dbForge Studio automates this process and offers a wizard to guide you. You will get a correct and painless way to:

  • Import data into a table from MS Access (2003, 2007+), CSV, DBF (Foxpro, dBase III, dBase IV, dBase 7), MS Excel, Text, XML formats
  • Migrate data from other servers
  • Customize the import

One more benefit is that you can optimize your import by saving the import settings as a template for future usage for importing data with the help of the wizard, and get a customized import immediately next time.

To import data using the Data Import wizard, you need to do simple steps:

  1. Select an import format and a file with the data that you want to import.
  2. Select a destination table.
  3. Adjust data formats for the Source data.
  4. Set additional options to customize the import.
  5. Set a correspondence between the Source file content and columns of the Target table.
  6. Select a data processing mode, e.g., whether to add the records to the Target table or update the existing ones, or both.
  7. Define how dbForge Studio should handle errors during import and whether to write a log file.

Want to Find out More?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by dbForge Studio for Oracle.
All Features

All features

Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.
Request a demo

Request a demo

If you consider employing the Studio for your business, request a demo to see it in action.
Ready to start using dbForge Studio for Oracle?