Excel 2007 - MS Query Issue

[lkerr]

First, thank you in advance for your assistance.

Here's what I'm trying to do: I have two sheets in a workbook which I need to combine. I would normally just use vLookup to pull the columns. However, in this case, Sheet2 has multiple rows that correspond to one row in Sheet1. e.g:

Sheet 1 - Main Data
ID Name City St Member#
1 John Plain TX 0293
2 Sue King TX 0294

Sheet 2 - Member Info
Member# Date Reason
0293 01-07 Ill
0293 01-12 Late
0294 01-23 Cat died
0294 01-31 Why not

What I am desiring to do is create Sheet 3:
Member# Name Date Reason
0293 John 01-07 Ill
0293 John 01-12 Late
etc etc etc

Obviously, this is made up data, although similar to my situation. I am trying to use MS Query (thanks to Skip for his great FAQ -

http://www.tek-tips.com/faqs.cfm?fid=5829).

However, I get the error message that my data source contains no visible tables. I have all my data formatted as tables (visually and using Excel's silly pre-provided formats) and I still cannot figure out what is the problem.

Has anyone had this issue or can anyone think of something else to try? Thanks in advance, and my apologies for the mile-long post!

 

[SkipVought]

Hi,

Glad you found my FAQ helpful.

"no visible tables"

In the Add Tables window, click the OPTIONS button and check ALL boxes.

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}

 

[lkerr]

Thanks, Skip. Call me an idiot (I'm still learning Office 2007 vs 2003), but I can't find the "Add Tables" Window. Where should I be looking?

 

[SkipVought]

In the Query Editor...

Table > Add Table...

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}