IMPORT

Loads data values from an external source into the currently selected database.

Syntax

IMPORT numeric dataFile fileType y/n ruleLoc rulobjName y/n [ErrorFile]

For an SQL data source, the syntax is as follows:

IMPORT 4 SQLUserName SQLUserPassword Ruleloc rulobjName y/n [ErrorFile]

numeric Location of the dataFile file. Values:
1 - Local/client data file.
2 - Remote/server data file.
3 - File.
4 - SQL source.
dataFile Name of data source file.
fileType File type of dataFile. Values:
1 - Excel file.
2 - Lotus 2 file.
3 - Lotus 3 file.
4 - Text file.
5 - Lotus 4 file.
y/n Whether to use rules when importing dataFile.
ruleLoc Location of the rulobjName file. Values:
1 - Local/client rule object file
2 - Remote/server rule object file
3 - File. Use option 3 if the file is not an Analytic Services object, or if you want to specify the full path name. Otherwise, Analytic Services looks in the <APPNAME>/<DBNAME> directory.
rulobjName Name of the rules file.
y/n Whether to abort on error.
SQLUserName User name that connects to the SQL database.
SQLUserPassword User password for the SQL database..
ErrorFile The name of the error file. This is required only if you choose not to abort on error.

Notes

Example

IMPORT 2 "ACTUALS" 4 "Y" 2 "ACTUALS" "Y";

See Also

LOADDATA
UPDATEFILE
BUILDDIM

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com