MS Query: joining table value to value in spreadsheet

S

Stefan Keydel

Hello,

Please forgive me if this has been addressed many times already!

I'm using Excel 2004 on the Mac. I'm using MS Query to query an Oracle
database and I want to join a field in the Oracle database to a field
in my Excel spreadsheet.

For example, suppose I have a column in my Excel spreadsheet with the
names of cities and suppose the Oracle database has a table with cities
and some of their key metrics (population, square acreage, etc.). What
I want to do is return a row of data for each city by joining the city
field in my spreadsheet with the city in the Oracle table.

Is this possible? I have no trouble running queries against the Oracle
database and returning data to the spreadsheet, but I can't seem to
figure out how to specify this join in the query.

Thanks,

Stefan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Query: joining table value to value in spreadsheet 4
Append Crosstab Query to Existing Table 0
Linking data in MS Word into Excel 5
Dumb question alert! What program to use? 0
Creating a Chart on form from selected data in query. 0
Dealing with a Pivot Table (when I don't want to) 0
Auto populate value from one task to another in MS PROJECT 0
Mail Merge Directory Conditional Page Break 0

Top