Valid select statements using OLEDB and Excel
Hello,
I am looking for any info about valid select statements when using the OLEDB
with Excel.
Some quick questions I am trying to answer:
1. Can you say something like "Select Col1, Col2 from Worksheet"
2. Are "where'"statements valid? "Select * from Worksheet where col1 =
'dan'"
I did some googling and found great information but nothing centralized on
the subject. Is there a website or document or link anyone can recommend that
discusses this topic in detail?
Thanks in advance!
Dan H.
|