Syntax for query-ing MS Excel data vith ADO



Hi,


I have some questions about right syntax for querying
MS Excel data.

This syntax works fine under Borland C++ Builder and ADO:
SELECT * FROM [Sheet1$]

But this one:
SELECT * FROM [Sheet1$A1:B3]
....doesn't (I cought an exception in try&catch).

Does anyone know how can I select only sheets in some range
(A1 to B3, for example)



--
Best Regards,
Vladimir Stefanovic


.