• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 216
  • Last Modified:

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...
0
jaymz69
Asked:
jaymz69
  • 2
1 Solution
 
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

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now