现在我在毕业设计中有一个很大的问题,我的导师让我实现一个从access数据库到EXCEL数据的转换,我有些不太懂,求大侠帮忙。下面是一个EXCEL到ACCESS的转换:
Private Sub cmdLoad_Click()
Dim excel_app As Object
Dim excel_sheet As Object
Dim db As Database
Dim new_value As String
Dim row As Integer Screen.MousePointer = vbHourglass
DoEvents ' Create the Excel application.
Set excel_app = CreateObject("Excel.Application") ' Uncomment this line to make Excel visible.
' excel_app.Visible = True ' Open the Excel spreadsheet.
excel_app.Workbooks.Open FileName:=txtExcelFile.Text ' Check for later versions.
If Val(excel_app.Application.Version) >= 8 Then
Set excel_sheet = excel_app.ActiveSheet
Else
Set excel_sheet = excel_app
End If ' Open the Access database.
Set db = OpenDatabase(txtAccessFile.Text) ' Get data from the Excel spreadsheet and insert
' it into the TestValues table.
row = 1
Do
' Get the next value.
new_value = Trim$(excel_sheet.Cells(row, 1)) ' See if it's blank.
If Len(new_value) = 0 Then Exit Do ' Insert the value into the database.
db.Execute "INSERT INTO TestValues VALUES (" & _
new_value & ")" row = row + 1
Loop ' Close the database.
db.Close
Set db = Nothing ' Comment the rest of the lines to keep
' Excel running so you can see it. ' Close the workbook without saving.
excel_app.ActiveWorkbook.Close False ' Close Excel.
excel_app.Quit
Set excel_sheet = Nothing
Set excel_app = Nothing Screen.MousePointer = vbDefault
MsgBox "Copied " & Format$(row - 1) & " values."
End Sub' Note that this project contains a reference to
' Microsoft DAO 3.51 Object Library.
Private Sub Form_Load()
Dim file_path As String file_path = App.Path
If Right$(file_path, 1) <> "\" Then file_path = file_path & "\"
txtExcelFile.Text = file_path & "XlsToMdb.xls"
txtAccessFile.Text = file_path & "XlsToMdb.mdb"
End Sub
Private Sub cmdLoad_Click()
Dim excel_app As Object
Dim excel_sheet As Object
Dim db As Database
Dim new_value As String
Dim row As Integer Screen.MousePointer = vbHourglass
DoEvents ' Create the Excel application.
Set excel_app = CreateObject("Excel.Application") ' Uncomment this line to make Excel visible.
' excel_app.Visible = True ' Open the Excel spreadsheet.
excel_app.Workbooks.Open FileName:=txtExcelFile.Text ' Check for later versions.
If Val(excel_app.Application.Version) >= 8 Then
Set excel_sheet = excel_app.ActiveSheet
Else
Set excel_sheet = excel_app
End If ' Open the Access database.
Set db = OpenDatabase(txtAccessFile.Text) ' Get data from the Excel spreadsheet and insert
' it into the TestValues table.
row = 1
Do
' Get the next value.
new_value = Trim$(excel_sheet.Cells(row, 1)) ' See if it's blank.
If Len(new_value) = 0 Then Exit Do ' Insert the value into the database.
db.Execute "INSERT INTO TestValues VALUES (" & _
new_value & ")" row = row + 1
Loop ' Close the database.
db.Close
Set db = Nothing ' Comment the rest of the lines to keep
' Excel running so you can see it. ' Close the workbook without saving.
excel_app.ActiveWorkbook.Close False ' Close Excel.
excel_app.Quit
Set excel_sheet = Nothing
Set excel_app = Nothing Screen.MousePointer = vbDefault
MsgBox "Copied " & Format$(row - 1) & " values."
End Sub' Note that this project contains a reference to
' Microsoft DAO 3.51 Object Library.
Private Sub Form_Load()
Dim file_path As String file_path = App.Path
If Right$(file_path, 1) <> "\" Then file_path = file_path & "\"
txtExcelFile.Text = file_path & "XlsToMdb.xls"
txtAccessFile.Text = file_path & "XlsToMdb.mdb"
End Sub
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货