excel怎么用sql查呢? dim i as integer dim mySheet as Excel.WorkSheet for i=0 to workbooks.worksheets.count set mySheet = workbooks.worksheets(i) 操作 mySheet.Name next i
Option ExplicitPrivate Sub Command1_Click() Dim mFileCon As ADODB.Connection Dim rst As RecordsetSet mFileCon = New ADODB.Connection mFileCon.Open Text1.TextSet rst = mFileCon.OpenSchema(adSchemaTables)List1.ClearDo While Not rst.EOF List1.AddItem rst!TABLE_NAME rst.MoveNext
Looprst.Close Set rst = Nothing mFileCon.Close Set mFileCon = NothingEnd Sub '其中加入了一个TEXTBOX和一个LISTBOX 'TextBox中的Text为连接Excel的连接字符串。
dim i as integer
dim mySheet as Excel.WorkSheet
for i=0 to workbooks.worksheets.count
set mySheet = workbooks.worksheets(i)
操作 mySheet.Name
next i
我觉得应该可以用SQL查吧,既然可以查数据就可以查sheet 名呀。
Dim mFileCon As ADODB.Connection
Dim rst As RecordsetSet mFileCon = New ADODB.Connection
mFileCon.Open Text1.TextSet rst = mFileCon.OpenSchema(adSchemaTables)List1.ClearDo While Not rst.EOF
List1.AddItem rst!TABLE_NAME
rst.MoveNext
Looprst.Close
Set rst = Nothing
mFileCon.Close
Set mFileCon = NothingEnd Sub
'其中加入了一个TEXTBOX和一个LISTBOX
'TextBox中的Text为连接Excel的连接字符串。