Microsoft Query: Data Source .xls Files

Hi all -

Trying to work through tutorial on creating offline cube from an Excel file, A CompleteGuide to PivotTables: A Visual Approach, Cornell, ISBN 1-59059-432-0, pg 248.

Steps I am taking:
1. Click on Data Menu
2. Import External Data
3. New Database Query

On Databases tab
4. Click on Excel Files*
5. Click on Browse Button

I migrate to the loction of the sample files I downloaded, but no files appear in the Browse Data Sources dialog window.

Files of type drop down reveals only "Data Sources" (w/o quotes)

I browsed the folder with Windows Explorer. There are several Excel files in the folder as well as sample, .cub and .mdb files.

I do have Excel 2007 installed on the PC as well, but working through the tutroail with Excel 2003.

Any ideas why the Excel files are not visible?
Thanks all
Regards,
marc

Re: Microsoft Query: Data Source .xls Files

Hi Dave,

Yes, Excel Files is selected in the databases tab of the Choose Source Dialog Box
Still, I do not see any Excel files listed.

I also tried MS Access Database, I browsed to the folder containing the download files
I cannot see .mdb files either.

I tried everything on another PC in the house with only Office 2003 no Office 2007 a in my primary system.

Still, no files are visible when I browse through Choose Data Source in MS Query

Any ideas what is going on?
Thanks
Regards,
marc

Re: Microsoft Query: Data Source .xls Files

Thanks Dave,

That solved the problem.

Thanks for your help
Regards,
marc