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.