I have Progress v9.1E running a custom application.
I have had much luck exporting into Excel and PDF files.
Now, I'd like to import an Excel Spreadsheet into some temp table(s).
I have found how to open and display an existing Excel file.
I need to know how to step through the cells and assign them to the table/fields so I can work with the imported data in Progress.
I estimate that I will need to create some data ahead of time, and I can do that.
Let's say I have a temptable called tt-rfqitemd with the fields, item, description, qty, delivery, target-price, note.
Let's say I have a spreadsheet with the same fields.
1: Is it possible to run through the columns until I find the field named "item" for example and import it into the tt-rfqitemd.item field? Same for the balance fields, so I don't need to adjust the placement of the fields on the Excel?
2: What would the best commands be for the actual importing? Are there special considerations for the different datatypes?
I'd really appreciate the ideas of an expert. I am sure that once you start doing it all of the time, it will be as intuitive as exporting into Excel but at this point, I can only import csv files.
Thanks!!
I have had much luck exporting into Excel and PDF files.
Now, I'd like to import an Excel Spreadsheet into some temp table(s).
I have found how to open and display an existing Excel file.
I need to know how to step through the cells and assign them to the table/fields so I can work with the imported data in Progress.
I estimate that I will need to create some data ahead of time, and I can do that.
Let's say I have a temptable called tt-rfqitemd with the fields, item, description, qty, delivery, target-price, note.
Let's say I have a spreadsheet with the same fields.
1: Is it possible to run through the columns until I find the field named "item" for example and import it into the tt-rfqitemd.item field? Same for the balance fields, so I don't need to adjust the placement of the fields on the Excel?
2: What would the best commands be for the actual importing? Are there special considerations for the different datatypes?
I'd really appreciate the ideas of an expert. I am sure that once you start doing it all of the time, it will be as intuitive as exporting into Excel but at this point, I can only import csv files.
Thanks!!