Importing Data From Text Files and Spreadsheets

For best results, you should import data directly from databases when possible. You can, however, import data from file-based data sources, such as text or .csv files. Before you import data from a non-database file into your production database, you should first import the data into a test copy of your database and verify that the import completes without error.

When you import data from a Microsoft Excel spreadsheet, be aware that spreadsheets do not qualify the "type" of columns as expected. Even though a column may appear to contain only text values, an informational query through ODBC may qualify the column to be numeric. In addition, Excel can incorrectly define textual column types that cause ODBC binding problems. To safely import Excel data into SBM, import that data into an ODBC-supported database, such as Microsoft Access or Microsoft SQL Server, and then import the database into your SBM database.
Note: Spreadsheet worksheets are interpreted by the Import Data Wizard as the source table name. If your worksheet contains special characters or spaces, you must rename the worksheet to remove them before importing data.

Related Topics

Preparing to Import Data

Considerations for All Types of Data Imports

Steps for Importing Data From a Generic ODBC Database