Link to home
Start Free TrialLog in
Avatar of jaymz69
jaymz69

asked on

Excel linked to ODBC

Is it possible to have a spread sheet linked via a ODBC to the AS400's DB2?

Then when I press a refresh Button (a macro to fire off the odbc connection and update records)
the spreed sheet connects the link and pulls the data in.

I know I will have to map the feilds somehow too...
ASKER CERTIFIED SOLUTION
Avatar of Member_2_6169280
Member_2_6169280
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jaymz69
jaymz69

ASKER

how would I pass a query to it?

where can I build it in Excel?


Thanks
Please check the following:
http://www.oraxcel.com/projects/sqlxl/help/techniques/connecting/db2_odbc.html

Here is about Excel query
http://www.exceluser.com/explore/msquery1_1.htm

You could also post another question to get more attention.