• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1348
  • Last Modified:

Application.ImportXML

I am trying to use the following command in VB code in an Access 2003 data project:

Application.ImportXML (filename) acAppendData

I am getting an error when I try to call this code.  Do I need to dim something special?  I can run the command manually under FILE/Get External Data / Import / XML and successfully import the file.

What am I doing wrong?

HELP!!!!!
0
StardustMan
Asked:
StardustMan
1 Solution
 
WesleySaysHiCommented:
Correct Subroutine to import data and structure of a xml file:

Private Sub ImportXMLFile()

   Const STRUCTURE_AND_DATA = 1

   Application.ImportXML DataSource:="filename.xml", _
       ImportOptions:=STRUCTURE_AND_DATA

End Sub

Regards,

Wesley
0
 
StardustManAuthor Commented:
Thanks so much.

0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now