sub getdata Dim cn As ADODB.Connection Dim re As ADODB.Recordset Dim cnstring As String Dim sql As String Set cn = New Connection cnstring = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\ADAM\ADAM_DataAccess\" & filename & ".mdb" cn.ConnectionString = cnstring cn.Open Set rs = New Recordset sql = "SELECT 物料编码,物料规格 FROM 表 where 名称 = ” & 你的单元格如 cell(m,n) rs.Open sql, cn, 3, 1
cell(m+1,n).Clear
cell(m+1,n).CopyFromRecordset rs rs.Close cn.Close Set rs = Nothing Set cn = Nothing
sub getdata
Dim cn As ADODB.Connection
Dim re As ADODB.Recordset
Dim cnstring As String
Dim sql As String
Set cn = New Connection
cnstring = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\ADAM\ADAM_DataAccess\" & filename & ".mdb"
cn.ConnectionString = cnstring
cn.Open
Set rs = New Recordset
sql = "SELECT 物料编码,物料规格 FROM 表 where 名称 = ” & 你的单元格如 cell(m,n)
rs.Open sql, cn, 3, 1
cell(m+1,n).Clear
cell(m+1,n).CopyFromRecordset rs
rs.Close
cn.Close
Set rs = Nothing
Set cn = Nothing
End Sub
否则你就得专门保存好这个表, 免得不小心删除了就麻烦了.