select URL from [qas$] where Month='March' and Year=2000
Note that the table name is the name of the worksheet with a $ appended to the end. You have to append the $ in order for the query to work. Why?
Because spreadsheets aren't tables... You have several ways of telling, which data you want: [qas$] refers to the entire worksheet qas [qas$B2:G20] refers to the unnamed range B2:G20 or you can use named ranges: then you can use the name of the range like any "normal" table ( select * from myRangeInQas )
Because. The brackets are there because $ is a reserved character in SQL. Life is never easy. -----------------------
Now all I want to do is SELECT *...I don't need anything fancier than that, I'm just trying to publish the entire worksheet. No variation on the above code snippet seems to work.
Has anybody gotten SQL queries into excel to work? And how did you do it?
The way you described works fine for me... Does the first row of your worksheet show the columnnames? Any of them starting with blank ? Maybe you tell us, what happens when "it doesn't work"... Chris