先引用microsoft excel *.0 ....,定义一个数组保存你的数据
Dim appexl As Excel.Application,i as integer,j as integer
Set appexl = New Excel.Application
appexl.Workbooks.Open xlsfilePATH, 1, 0, , , , 1, , , 1, 0
appexl.AlertBeforeOverwriting = False '自动保存
appexl.Sheets(2).Cells(i, j)=YOUdata '将你的数据写入excel
....
appexl.workbooks.close
appexl.quit
Dim appexl As Excel.Application,i as integer,j as integer
Set appexl = New Excel.Application
appexl.Workbooks.Open xlsfilePATH, 1, 0, , , , 1, , , 1, 0
appexl.AlertBeforeOverwriting = False '自动保存
appexl.Sheets(2).Cells(i, j)=YOUdata '将你的数据写入excel
....
appexl.workbooks.close
appexl.quit
就可以打开你原来已设计好的文件嘛,怎么会重建?
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\Book1.xls;Extended Properties=Excel 8.0;"
conn.Execute "Insert into MyTable (FirstName, LastName)" & _
" values ('Bill', 'Brown')"
conn.Execute "Insert into MyTable (FirstName, LastName)" & _
" values ('Joe', 'Thomas')"
conn.Close
另一例:
cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & .FileName & ";" & _
"Extended Properties=""Excel 8.0;"""strSQL = "insert into [" & sSheetName & "$] Select * FROM [;database=" & sAccessDBPath & "]." & sAccessTable
cnn.Execute strSQL
另一例:
cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & .FileName & ";" & _
"Extended Properties=""Excel 8.0;"""strSQL = "insert into [" & sSheetName & "$] Select * FROM [;database=" & sAccessDBPath & "]." & sAccessTable
cnn.Execute strSQL
Provider=MSDASQL.1;Persist Security Info=False;Extended Properties="Driver={Microsoft Excel Driver (*.xls)};DBQ=c:\book1.XLS"
但連接上後要怎樣才能將數據導入指的單元格中
例如:
在窗體中有一個text1
要才樣才能將TEXT1中的數據導入EXCEL中的B3單元格中,
而不改變其它單元格裡的數據
Dim oExcelApp As Object ' Create a reference to the currently running excel application
Set oExcelApp = GetObject(, "Excel.application")
' Make the Excel Application Visible.
oExcelApp.Visible = True
' Fill Excel Cell
oExcelApp.Sheets(2).Cells(B,3) = Text1
Set oExcelApp = GetObject(, "Excel.application")
这里有错