Access 2003 XML import not importing all columns

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


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
Clipboard01.jpg
test732.inftab.xml
INFO-TABLE-X01.xsl
durickAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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?)
0
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
0
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...
0
durickAuthor Commented:
can you see what other tables are contained in the test732inftab.xml file? because it opens fine in excel
0
Scott McDaniel (Microsoft Access MVP - EE MVE )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:

http://www.databasejournal.com/features/msaccess/article.php/10895_3310901_2/Import-XML-Data-Into-Microsoft-Access.htm

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.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.