vb6.0怎么把excel的数据导入到access中?

2025-02-24 14:27:13
推荐回答(2个)
回答1:

如果你是标准的行列表的话,请试试:

Option Explicit

Sub change()

Dim fileToOpen
Dim Filename

fileToOpen = Application _
.GetOpenFilename("excel Files (*.xls), *.xls")
If fileToOpen <> False Then
Workbooks.Open (fileToOpen)
Else
End
End If
With ActiveSheet

ActiveWorkbook.SaveAs Filename:=1, FileFormat:=xlDBF4

Application.DisplayAlerts = False

Application.Quit

End With
End Sub

回答2:

怎么解决的啊!告诉下,我也在找。。。谢谢了!