To load parts into System Five using a Microsoft Excel file (.xls) perform the following:

1. Note where your Excel .xls file is located and create an ODBC connection to that file

Click the ODBC admin button picture

Choose to create a new data source using the MS Excel Driver

Give it a Data source name, the description is optional and then select your Excel workbook

Browse for the Excel File

Once selected, perform your ODBC partload by selecting your ODBC Data source name for the Excel file. Also note that you may need to enter in the SQL statement for loading the items for sheet1

SELECT * FROM “Sheet1$” (Where sheet1$ is the name of sheet one. It may be called something else)