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...
jaymz69Asked:
Who is Participating?
 
royhsiaoCommented:
yes, it is possible.
Open the excel sheet go to data tab and click on the get external data.
select the ODBC which you need to configured and pass the query to it.


0
 
jaymz69Author Commented:
how would I pass a query to it?

where can I build it in Excel?


Thanks
0
 
royhsiaoCommented:
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.

Advertise Here