I am having problems with retreiving data from a worksheet where its name
contains spaces.

SELECT * FROM [<SourceSheet$A1:H100];

When <SourceSheet is "My Sheet", I get the message "The Microsoft Jet
database engine could not find the object...". I modified source sheet to
look like 'My Sheet', but that didn't work either.

What is the proper syntax for a source sheet containing spaces?

M