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.
Copyright © 2001–2019 Micro Focus or one of its affiliates. All rights reserved.