Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Michael Pavitsky: "SQL Maestro Group provided the kind of services and support for managing PostgreSQL data expected in a true business partnership. Their devotion to customer satisfaction and cost curtailment is a pleasure for PostgreSQL users. I wouldn?t hesitate to recommend PostgreSQL Data Wizard to any of my peers and I know and trust they will surpass all expectations".
Josh Armstrong: "I absolutely love this software! It will me take our migration time down by an order of magnitude. It has especially helped with my indexing as my database contains many complex ones".

More

Add your opinion

Customers
Download Buy

PostgreSQL Data Wizard online Help

Prev Table of Contents Next

Data Import

Data Import wizard provides you with a graphical user interface to import data from the most popular files formats into existing PostgreSQL  tables. It allows you to adjust data formats, empty target tables, execute custom SQL scripts, etc. To run the wizard, use the Run Data Import Wizard link at Home page.

 

The following formats are supported:
 

•Microsoft Office Excel 95-2003
•Microsoft Office Excel 2007 and higher
•Microsoft Office Access 95-2003
•Microsoft Office Access 2007 and higher
•Delimiter-separated values (CSV, DSV, TSV);
•Text files (Fixed-width columns)
•DBF
•XML
•ODBC data source (any data source accessible via ODBC driver or OLE DB provider such as SQL Server, Oracle, MySQL, MS Access, Text files, MS Excel, etc).

 

To import data,

•Set connection properties of the database to import data to;
•Select the format to use for the input data;
•Select the tables where you want to import the data;

 

See also: Templates



Prev Table of Contents Next