Hello a quick question regarding excel driver. does this driver support vba sql syntax? meaning Can my query look like this
"SELECT * FROM [SALES$];"
or
"SELECT [SALE_ID],[SALE_DATE],[QUANTITY],[NAME],[PRICE]
FROM [SALES$A1:E101]
WHERE [SALE_DATE] = #12/6/2003#
ORDER BY [SALE_ID];"
and it will still work?
Thank you.
|
It supports standard SQL 92 syntax, not SQL VBA.
|