Transferring data between heterogeneous data sources

When two or more data sources are opened in BaseNow as connections in the Object Browser, the program can transfer the data from one data source to another. The program can access data regardless of the database type.

The program works with following database formats:

•  Microsoft Access databases

•  Microsoft SQL Server

•  Oracle

•  fixed-width text files

•  delimited text files

•  Paradox

•  dBASE

•  Microsoft Excel

•  Lotus 1-2-3 spreadsheets

In case some database is in a format that is not listed above, the program will most probably be able to connect to it if it supports OLE DB or ODBC standards.

Related Topics:

About exporting and importing data

Automate importing and exporting

About Import/Export Wizard

About copying and pasting data

When source and destination columns do not match

Column mappings

Move and copy records to another table