Syntax for query-ing MS Excel data vith ADO
- From: "Vladimir Stefanovic" <antivari@xxxxxxxxxxxx>
- Date: Fri, 13 Apr 2007 15:49:34 +0200
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
.
- Prev by Date: Re: Copy Records From Remote Database
- Next by Date: Recordset Field - modifiable default values?
- Previous by thread: Re: Copy Records From Remote Database
- Next by thread: Recordset Field - modifiable default values?
- Index(es):