Kbase 32952: How to pull data from an Excel file into a Progress table
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/10/1998 |
|
Solution ID: P2952
GOAL:
How to pull data from an Excel file into a Progress table
GOAL:
You have an Excel file with some data and you want to place this data into a Progress table.
FACT(s) (Environment):
Progress 9.x
FIX:
You have three options to achieve the data transfer:
Option 1
Save the Excel file as a CSV (comma delimited) or as Text (Tab delimited)
file.
Use Progress 4GL commands to read the file and import the data into a
table (commands like IMPORT, ENTRY and NUM-ENTRIES).
See also: P4068, "How to export or import TAB delimited data"
Option 2
Save the Excel file as DBF.
Import the DBF file by using the Progress Data Dictionary.
Option 3
Read the data cell by cell using OLE.