我要使用ado修改Excel数据,可以吗?读取是可以的,但不知道如何修改
解决方案 »
- 麻烦高手比较一下以下2段代码
- 如何实现让某段程序每天12点自动定时执行,谢谢!急急!
- 关于安装??(高分)
- 谁帮我一下,我是写JSP的,现在碰到一个问题,急需解决(很急),怎么样可以把一个目录(有很多嵌套的文件夹)最底层的文件夹放在同一个
- 能够用ADO显示出当前连接的数据库中的所有表吗?
- 如何将图片文件缩小正常比例????????
- 用sql-dmo备份数据库,备份文件如何写到局域网内的机子(目录非共享)上?
- 今天加班的vb版友们:都在做些什么项目啊??
- 有实现IE自动完成功能的例子吗?
- ???请教高手我用winnt+VB6+ACCESS97用ODBC连接开发数据库程序,在别的机子上运行(不论是98或NT)都提示我说“ADO提供者找不到”!
- 把form中的函数功能写到modul中的问题??
- VB 读取多行csv文件的问题(急)
sql2 = "Select * FROM [Transfer$]"
rs2.Open sql2, cn2, adOpenStatic, adLockOptimistic
For j = 0 To rs2.RecordCount - 1
If j > 5 Then
Exit For
End If
rs2.Fields(1).Value = strScanVar(j)
rs2.update
rs2.MoveNext
Next
rs2.Close
Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim strConnect As String
On Error Resume Next strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\TestExcel.xls;" & _
"Extended Properties=""Excel 8.0;HDR=YES;IMEX=0"""
Set cn = New ADODB.Connection
cn.Open strConnect
'创建表和字段
cn.Execute "CREATE TABLE TestData (myField text)"
'插入测试数据
cn.Execute "INSERT INTO TestData(myField) VALUES ('H1 -2 * K1');"
cn.Execute "INSERT INTO TestData(myField) VALUES ('K2');"
cn.Execute "INSERT INTO TestData(myField) VALUES ('H10 +2 + K1');"
cn.Execute "INSERT INTO TestData(myField) VALUES ('S1 -20 - K1');"
cn.Execute "INSERT INTO TestData(myField) VALUES ('D / 2 * K1');"
cn.Execute "INSERT INTO TestData(myField) VALUES ('H1 /2 / K1');"
cn.Execute "INSERT INTO TestData(myField) VALUES ('H1 * 2 * K1');"
cn.Execute "INSERT INTO TestData(myField) VALUES ('TEST');"
cn.Execute "INSERT INTO TestData(myField) VALUES ('H1 + 2 - K1 * D /C');"
'查询测试
Set rs = cn.Execute("select myField from TestData WHERE myField not like '%[/*+-]%';")
While Not rs.EOF
Debug.Print rs!myField
rs.MoveNext
Wend
cn.Close
Set rs = Nothing
Set cn = Nothing
MsgBox "finish"
Dim i As Integer
Dim j As Integer
Dim XlApp As New Excel.Application
Dim xlBook As New Excel.Workbook
Dim xlSheet As New Excel.Worksheet
Set XlApp = CreateObject("Excel.Application")
XlApp.Visible = True
Set xlBook = XlApp.Workbooks.Add
Set xlSheet = xlBook.Worksheets(1)xlSheet.Cells(j + 1, i + 1) = "123"
MSFlexGrid1.Rows = 17
a = (255 - 1) / MSFlexGrid1.Rows
MSFlexGrid1.Cols = 10
'b = (255 - 1) / MSFlexGrid1.Cols
For i = 1 To MSFlexGrid1.Rows
MSFlexGrid1.Row = i - 1
For j = 1 To MSFlexGrid1.Cols
MSFlexGrid1.Col = j - 1
MSFlexGrid1.CellBackColor = RGB(0, 0, 255 - i * a)
MSFlexGrid1.CellForeColor = RGB(255, 255, i * a)
MSFlexGrid1.Text = i * j
Next j
Next i
End SubPrivate Sub MSFlexGrid1_DblClick()
Dim i As Integer
Dim j As Integer
Dim XlApp As New Excel.Application
Dim xlBook As New Excel.Workbook
Dim xlSheet As New Excel.Worksheet
Set XlApp = CreateObject("Excel.Application")
XlApp.Visible = True
Set xlBook = XlApp.Workbooks.Add
Set xlSheet = xlBook.Worksheets(1)
xlSheet.Cells(3, 1) = "i"
For i = 0 To MSFlexGrid1.Rows - 1
MSFlexGrid1.Row = i
For j = 0 To MSFlexGrid1.Cols - 1
MSFlexGrid1.Col = j
xlSheet.Cells(i + 3, j + 1) = MSFlexGrid1.Text
Next j
Next i
Exit Sub
End Sub
下面我已將程序代码做成模块,只要导入必要之参数即可!此一模块共有四个参数:
1、sSheetName:要导出资料的文件名称 (Sheet name),例如 Sheet1
2、sExcelPath:要导出资料的 Excel 档案路径名称 (Workbook path),例如 C:\book1.xls
3、sAccessTable:要导入的 Access Table 名称,例如 TestTable
4、sAccessDBPath:要导入的 Access 档案路径名称,例如 C:\Test.mdb在声明中加入以下:Private Sub ExportExcelSheetToAccess(sSheetName As String, _
sExcelPath As String, sAccessTable As String, sAccessDBPath As String)
Dim db As Database
Dim rs As Recordset
Set db = OpenDatabase(sExcelPath, True, False, "Excel 5.0")
Call db.Execute("Select * into [;database=" & sAccessDBPath & "]." & _
sAccessTable & " FROM [" & sSheetName & "$]")
MsgBox "Table exported successfully.", vbInformation, "Yams"
End Sub
使用范例如下:將 C:\book1.xls 中的 Sheet1 导入 C:\Test.mdb 成为 TestTableExportExcelSheetToAccess "Sheet1", "C:\book1.xls", "TestTable", "C:\Test.mdb"
另外主题帖的问题没说清楚,应该一次说清楚
对应着一个DLL