System Five Add-Ons & Integrations help simplify the way you do things.
Our catalog of services has topic-based, role-based, or technical plans that can help you maximize your software investment.
Copyright © 1984-present
Windward Software Systems Inc.
All Rights Reserved.
Privacy Policy
This is an old revision of the document!
Alternate Instructions for 64 bit versions of Excel (click link or see bottom of page)
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)
Alternate Instructions for 64 bit versions of Excel