已知 :
rs.Open "SELECT * FROM [Sheet1$], cn, adOpenStatic"
是取得Sheet1内所有资料~

求3个问题的解?
rs.Open "SELECT ID1 FROM [Sheet1$], cn, adOpenStatic"
1.是取得Sheet1内ID1栏位下的所有资料?

rs.Open "SELECT ID1 FROM [Sheet1$] WHERE 123, cn, adOpenStatic"
2.是取得Sheet1内ID1栏位下值为123的所有相关资料?

3.若表中有多个栏位~那要找出ID1的123且ID2的456且ID3的789的所有符合条件的资料~这该怎么写?

了解~
再问个问题~若ID1和ID2和ID3都有重复的资料~
该怎么下SELECT命令达到类似EXCEL中筛选栏位出不重复资料的方法?

试过可以~太感谢了~

rs.Open "select * from [sheet1$] where 'id1=123' and 'id2=456' and 'id3=789'"