Solved

Application.ImportXML

Posted on 2004-08-29
2
1,309 Views
Last Modified: 2012-05-05
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
Comment
Question by:StardustMan
2 Comments
 
LVL 5

Accepted Solution

by:
WesleySaysHi earned 500 total points
ID: 11928083
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
 

Author Comment

by:StardustMan
ID: 11928144
Thanks so much.

0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
changePi Challenge 15 104
topping3 challenge 14 70
drawing animated level bar based on numbers 3 88
autoit - check if option is checked in another program 2 111
This is an explanation of a simple data model to help parse a JSON feed
This is about my first experience with programming Arduino.
An introduction to basic programming syntax in Java by creating a simple program. Viewers can follow the tutorial as they create their first class in Java. Definitions and explanations about each element are given to help prepare viewers for future …
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now