Solved

Excel linked to ODBC

Posted on 2011-03-10
3
211 Views
Last Modified: 2012-05-11
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
Comment
Question by:jaymz69
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 6

Accepted Solution

by:
royhsiao earned 500 total points
ID: 35096348
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
 

Author Comment

by:jaymz69
ID: 35096386
how would I pass a query to it?

where can I build it in Excel?


Thanks
0
 
LVL 6

Expert Comment

by:royhsiao
ID: 35117572
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

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

732 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question