Retrieve Data via PowerBuilder, MS Excel from Progress DB

alfiee

New Member
Hello All,

I would appreciate any response on this.

plus_marca i need your input once again.

I can retrieve data from a progress db thru ms access and crystal report 9.2.

However, in powerbuilder and ms excel I can only view the table structure and not retrieve the data.


Thanks in advance.
 
Hello marca,

Am going through excel menu

Data -> Import External Data -> Import Data ->New source -> ODBC DSN -> ODBC Data source/ Progress SQL 92 driver

Thanks
 
Hello All,

I am now able to retrieve the data. The solution is quite simple. Powerbuilder required putting the table name in quotes for reasons best known to them.

e.g. pub.tablename should be pub."tablename"

Thanks for all the help so far
 
Back
Top