View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] DapperDanH@nospam.nospam is offline
external usenet poster
 
Posts: 4
Default 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.