Excel 2k-MS Query Can't fix "No visible tables..." error.

[RSJohnson]

I am trying to create my first query using MS Query. I can not understand the instructions in Excel Helpnor can I find an explaination of this error. Can someone tell do 1, do 2, do 3, etc. or point me to simple non-Microsoft speak instructions for using MS Query.

 

[SkipVought]

semaphore,

There is the database you want to query? What kind of database?

Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[RSJohnson]

I want to use Excel worksheets as data sources. Actually it is to follow up on a suggestion you gave me a couple of weeks ago.

SELECT {your fields Selection}
FROM Sheet1, Sheet2
WHERE Sheet1.Key1 = Sheet1.Key1
AND Sheet1.Key2 = Sheet2.Key2

My current code stops processing for not appearent reason I have shought help but got no takers. I need to move forward so, I have to try something else, in this try to get the results I need by using queries. The instructions on using MS Query are not clicking in my brain.

 

[SkipVought]

If you use Excel as the data source, you must

1) have one table per sheet
2) each table must be contiguous
3) each table must have a single heading row

The QBE grid will be the meand of Adding tables and relating them.

If your macro record EDITING you query, you can see the syntax for the code that is required.



Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[RSJohnson]

Thanks, This seems to be clear and specific.