|
- Option Explicit
- '引用:microsoft access 11.0 object library
- Sub TransferDataIntoAccess()
- Dim myData As String, myTable As String
- Dim myFile As String, myRange As String
- Dim wb As Workbook
- Dim ws As Worksheet
- Dim myAccess As Access.Application
- Set wb = ThisWorkbook '指定工作薄
- Set ws = wb.Sheets("林权证数据库") '指定工作表名称
- myData = wb.Path & "\林权证数据.mdb" '指定新数据库名称(完整路径)
- myTable = "林权证数据" '指定数据库的数据表名称
- myFile = wb.FullName '指定工作薄名称(完整路径)
- '指定工作表数据区域字符串
- myRange = ActiveSheet.UsedRange.Address(False, False)
- '删除已经存在的同名数据库文件
- On Error Resume Next
- Kill myData
- On Error GoTo 0
- '引用access对象
- Set myAccess = New Access.Application
- With myAccess
- .NewCurrentDatabase myData '创建新数据库
- '将指定工作表数据导入Access数据库
- .DoCmd.TransferSpreadsheet acImport, 8, myTable, myFile, True, myRange
- End With
- MsgBox "工作表数据已成功保存到数据库!", vbOKOnly
- myAccess.CloseCurrentDatabase '关闭数据库
- '释放变量
- Set myAccess = Nothing
- Set wb = Nothing
- Set ws = Nothing
- End Sub
复制代码 你需要重新整理你的数据,好似原始数据有问题。
|
|