How to load Excel content into a FOCUS database

Technique

Product: DataMigrator

Release: 8205

Primary OS: Windows

Solution Date: 2021-04-01

Problem

How to load Excel content into a FOCUS database.

Solution

With a Master File for the Excel file, you can read everything from the Excel file and write it into a FOCUS database in baseapp using the following:

APP HOLD BASEAPP

TABLE FILE ExcelFile

PRINT *

ON TABLE HOLD AS XXX FORMAT FOCUS

END

Information is published on an "as is" basis without a warranty of any kind. Information Builders, Inc. ("IBI") hereby represents that such information has not been subject to any formal testing or review by IBI. IBI assumes no responsibility for usage of such information, including the implementation of solutions associated therewith. The customer assumes responsibility for the results obtained from such information. IBI is not responsible for and shall not be held liable for the results obtained, including but not limited to any errors, delays or omissions. IBI disclaims any liability for the completeness or accuracy of such information.