From: mikebres on 19 Feb 2010 08:58
I have been experimenting with using ADO to work with Excel data. I had some
obstacles with the SQL until I stumbled across a web site that mentioned the
table name needed a special format. Instead of using a table name like DATA,
instead I had to use the format of [DATA$].
So I was wondering does anybody know of a source (document, web site, etc.)
that explains all of the peculiarities of using SQL with Excel?