Sample import files

A sample import file is supplied with Office Plus. It is called Import2.txt and is in:C:\Documents and Settings\All Users\Shared Documents\Infor\BI\OLAP\Data\Tutor_EN.

In the same location is a sample Microsoft Excel file called Import.xls.

In cell C14 of Import.xls is a DBSET formula which writes to cell C13 the value specified by cells B4, B5, B7, B8 and C12.

In cell B6 is an AT.GET formula. This looks up the product code of the product in cell B1 and returns the product name.

To run an import with these sample files, create a database alias for the TUTOR_EN database.

SeeCreating a database alias.

Open Import.xls and then select Import2.txt in the Process Data dialog.