About exporting and importing data
In BaseNow, you can import and export data from a number of different
database, spreadsheet, and text file formats. BaseNow provides tools for
importing and exporting data to and from data sources, including text
files, ODBC data sources (such as Oracle databases), OLE DB data sources
(such as SQL Server), ASCII text files, and Excel spreadsheets.
Data may need to be exported or imported regularly. In this case, the
data can be exported to a text file and then read by the application.
Alternatively, you can copy data on an ad hoc basis. For example, you
can extract data from a database into
an Excel spreadsheet running on a portable computer and take the computer
on a business trip.
The program can connect to the database servers on a different locations
using TCP/IP protocol and it allows data to be distributed across an enterprise,
copying data between locations and synchronizing changes automatically
between different copies of data. For more information, see Automate
importing and exporting.
Automate importing and
data between heterogeneous data sources
About Import/Export Wizard
About copying and pasting
source and destination columns do not match
and copy records to another table