Access 2003 XML import not importing all columns

using following vba code to import an xml file into Access 2003
Application.ImportXML _
 DataSource:=strImportFileName, _

the xml file opens correctly in excel, but in access it only imports 6 columns, as shown
have tried using the .xsl file but it gives an error that '>' character was expected?

Tired of raking my brain another day on this problem
Who is Participating?
Scott McDaniel (Microsoft Access MVP - EE MVE )Connect With a Mentor Infotrakker SoftwareCommented:
Excel is a "flat file" database (so to speak), and your XML has multiple tables associated with, specifically on the shrsOrPrnAmt and VotingAuthority columns. Excel can manage that, but Access cannot do so natively with the ImportXML feature. You have to build your own XML import routine.

Here's an article that may get you started:

In that one, there are more than one table which must be filled from the XML file, much like your file. Try to adapt that code to your situation and post back here with any issues.
Jeffrey CoachmanMIS LiasonCommented:
What happens if you jut create the XML file for that one table?

How are you exporting the data?

Where is the XLM data coming from (Excel, Web, Other?)
durickAuthor Commented:
test732inftab.xml is the xml file  for just the information table, all 16 columns
it was created in Access 2003 vba with dom document commands
Jeffrey CoachmanMIS LiasonCommented:
Yes,  but the xml file contained other tables...
Create an xml file with only one table...

<it was created in Access 2003 vba with dom document commands >
What about just using the wizard to export...
durickAuthor Commented:
can you see what other tables are contained in the test732inftab.xml file? because it opens fine in excel
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.

All Courses

From novice to tech pro — start learning today.