Import data into MS Excel from Progress DB

L

lggoo

New Member
Dear folks,
Can anyone tell ,tell me how to import data from openedge 10.1B DB into MS Excel in a windows remote server client environment?

The primary objective is to abstract data from MFGPRO DB on the remote server for reporting purposes.

Is it possible to establish connection from client to server without having to install Openedge 10.1B on the client side?

What are the settings and drivers needed on each side?

Thank you in advance.
 
I found a method by creating a "File DSN" that reside on the server side and allow clients to gain access to the dsn file via shared network.

In my current scenario, I have about 20 users having to connect and import MFGPRO DB data into excel. Having only 3 client networking licenses is not feasible to acheive via "User DSN" approach.

Anyway, it works.
How it helps for others.

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