When I write a SQL statement to query an Excel Table that includes Cells with dates as the Labels (e.g. 1/1/2010, 2/1/2010, etc.) the SQL does not work.

Example: SELECT [Period], [Project], [Category], [1/1/2010]
FROM [M1XNQ_Summary]$ ;

I have tried # symbols, single quotes and double quotes.

Final answer?

BTW - I own the above book and use it daily! Love it!

Thanks in advance.

I'm no expert at vba, but i've learned two things: 1, No special symbols in column headers, and 2, make it all one word. Basically, name your column headers with the same rules that apply to naming variables in vba, I.E. start them with a letter, alphanumeric characters only, no spaces.

Also, be careful with putting an apostrophe (') in any data you'll be using sql on, totally botches up the works.