304323 ACC2002: How to Use ADOX to Create an SQL Pass-Through Query http://support.microsoft.com/kb/304323/
只是SQL字符串不同而已,自己改改就行了
'Modify the following connection string to reference an existing DSN for 'the sample SQL Server PUBS database. cmd.Properties _ ("Jet OLEDB:Pass Through Query Connect String") = _ "ODBC;DSN=myDSN;database=pubs;UID=sa;PWD=;" 这句我不懂阿,DSN database UID PWD 都要怎么设置阿
http://support.microsoft.com/kb/304323/
'the sample SQL Server PUBS database. cmd.Properties _
("Jet OLEDB:Pass Through Query Connect String") = _
"ODBC;DSN=myDSN;database=pubs;UID=sa;PWD=;"
这句我不懂阿,DSN database UID PWD 都要怎么设置阿
CommandText写查询的SQL就可以了