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...
Microsoft Excel

Avatar of undefined
Last Comment
royhsiao

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
royhsiao

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
jaymz69

ASKER
how would I pass a query to it?

where can I build it in Excel?


Thanks
royhsiao

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.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck