importing xls into progress DB

sureshp said:
dont kno exactly may be 9.x
Click to expand...

If you are running under Progress 9.x it will not be possible. In OpenEdge you can import an xls or whatever document you want into a blob or clob.

You can import the filename into your database and use it to open the the excel sheet from within you program.
 
Hi,

Have you tried to just export it into a csv with Excel and then read it into a temp-table with IMPORT. After that you can do with it what you want/need.....

Or do you require a process that can do all this "automagically" for you on a regular basis? If the latter, then on what platform are you wanting to do this (for instance Windows or UNIX)?

Paul
 
You must log in or register to reply here.
Back
Top