• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1371
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

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