Dim MyFile As String Dim strPath As String Dim strFile As String Dim cnAccess As Variant''strPath为文件夹的路径,strFile为文件夹里的文件 strPath = "C:\Temp" strFile = strPath & "\*.xml"
Set cnAccess = CreateObject("Access.Application") cnAccess.OpenCurrentDatabase "C:\book.mdb" MyFile = Dir(strFile, vbNormal)''获得符合条件的文件名 Do While MyFile<> "" ''循环查找 cnAccess.ImportXML MyFile,2 MyFile= Dir''如果和上次一样,DIR可以这么省写 Loop End If
xml格式如下
<?xml version="1.0" encoding="UTF-8"?>
<root>
<userTable>
<userName>danielinbiti</userName>
<userNum>0</userNum>
</userTable>
<userTable>
<userName>danielinbiti1</userName>
<userNum>1</userNum>
</userTable>
<userTable>
<userName>danielinbiti2</userName>
<userNum>2</userNum>
</userTable>
</root>
表结构如
表名叫userTable
表中有个字段名叫userName和userNum
代码如下:
Option Explicit
Private Sub Command1_Click()
Dim cnAccess As Variant
Set cnAccess = CreateObject("Access.Application")
cnAccess.OpenCurrentDatabase "C:\book.mdb"
cnAccess.ImportXML "c:\test.xml", 2
End Sub具体效果可以自己执行一下自己看,往表里的数据都怎么对应的可以实际操作后看一下就明白了
Dim strPath As String
Dim strFile As String
Dim cnAccess As Variant''strPath为文件夹的路径,strFile为文件夹里的文件
strPath = "C:\Temp"
strFile = strPath & "\*.xml"
Set cnAccess = CreateObject("Access.Application")
cnAccess.OpenCurrentDatabase "C:\book.mdb"
MyFile = Dir(strFile, vbNormal)''获得符合条件的文件名
Do While MyFile<> "" ''循环查找
cnAccess.ImportXML MyFile,2 MyFile= Dir''如果和上次一样,DIR可以这么省写
Loop
End If