Kbase P2952: How to pull data from an Excel file into a Progress table
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/9/2009 |
|
Status: Verified
GOAL:
How to pull data from an Excel file into a Progress table
GOAL:
How to IMPORT data from a Microsoft EXCEL file using 4GL/ABL?
GOAL:
How to load a 4GL/ABL database or TEMP-TABLE with data from a Microsoft EXCEL spreadsheet?
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
FIX:
There are three possible solutions:
1. Save the Excel file as a CSV (comma delimited) or as Text (Tab delimited) file and use the 4GL/ABL statements and functions like IMPORT, ENTRY and NUM-ENTRIES etc to read the file into the progress session.
2. Save the Excel file in the .txt file format and use the 4GL/ABL Data Administration Tool to import the data into the database table.
3. (Windows Only) Read the data cell by cell using OLE.