Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Valid select statements using OLEDB and Excel
1. "SELECT * FROM [Sheet1$A:E]"
2. "SELECT * FROM [Sales$A:E] WHERE Name='Bob'" Name being the column heading which will get treated as a recordset field. -- HTH Bob Phillips (remove nothere from email address if mailing direct) wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF Statements to Select Case??? | Excel Discussion (Misc queries) | |||
Excel MS Query multiple select statements | Excel Discussion (Misc queries) | |||
How do I Select Multiple entries from Valid list for a Cell | Excel Discussion (Misc queries) | |||
Select statements on the same sheet? | Excel Programming | |||
Using Select Case Statements | Excel Programming |