最直接的方法:
dim cn as new adodb.connection
dim rs as new adodb.recordset
cn.connectionstring = _
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\db1.mdb"
cn.open
set rs = cn.execute("select * from table1")
open "1.txt" for output as #1
do until rs.eof
for i = 0 to rs.Fields.count -1
print #1, rs.Fields(i) & vbTab
nexti
print #1,""
rs.movenext
loop
close #1
rs.close
set rs = nothing
cn.close
set cn = nothing