Importing xml file gives no data
I am trying to import a fairly large xml file into Access. I'm just using the External Data import option on the toolbar. It creates two tables with lots of records, but there is no data in the records.
Any suggestions?
Any suggestions?
ASKER
I've requested that this question be deleted for the following reason:
I cannot post the requested file because it is confidential company information.
I cannot post the requested file because it is confidential company information.
Posting a sample file was optional.
Besides, I just needed a "Sample" xml file (a file that exhibits this issue, not your actual data)
In any event, ... I posed XML file that imports just fine.
Did you examine it and test it?
The bottom line is that if this is one table, then you have to make sure that he system that creates this xml file can structure the data in a standard XML single table format.
(which my xml file is an example of.)
In other words, you would compare the xml elements in my file to the xlm elements in your file.
Al I ask is that you report back with your findings on my file, ...instead of abruptly asking that the Q be deleted.
JeffCoachman
Besides, I just needed a "Sample" xml file (a file that exhibits this issue, not your actual data)
In any event, ... I posed XML file that imports just fine.
Did you examine it and test it?
The bottom line is that if this is one table, then you have to make sure that he system that creates this xml file can structure the data in a standard XML single table format.
(which my xml file is an example of.)
In other words, you would compare the xml elements in my file to the xlm elements in your file.
Al I ask is that you report back with your findings on my file, ...instead of abruptly asking that the Q be deleted.
JeffCoachman
ASKER
What you are essentially saying here is that I should spend time either analyzing your file, or creating an extract of mine, even though it is not possible for me to post the one I want to work on. My file is infinitely larger and more complicated than the one you posted - we're talking, literally, hundreds of columns and 10s of thousands of rows.
If you are a regular follower of this site you are well aware that I happily pay 500 points for answers to the most rudimentary questions. Unfortunately, in this case, the demands of my job prevent me from sharing the file. Nothing that you provided was of any use to me.
Sorry.
If you are a regular follower of this site you are well aware that I happily pay 500 points for answers to the most rudimentary questions. Unfortunately, in this case, the demands of my job prevent me from sharing the file. Nothing that you provided was of any use to me.
Sorry.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I have no problems with this either way.
Buck,
Please don't take my posts as being "confrontational"
Nothing could be farther from the truth.
I did check your profile, ...and you are one of the better members here.
;-)
I just wanted to make sure that we had worked as far as we could on this...
I also realize that sometimes you can only dedicate a finite amount of time to a problem.
;-)
JeffCoachman
Please don't take my posts as being "confrontational"
Nothing could be farther from the truth.
I did check your profile, ...and you are one of the better members here.
;-)
I just wanted to make sure that we had worked as far as we could on this...
I also realize that sometimes you can only dedicate a finite amount of time to a problem.
;-)
JeffCoachman
Your file must conform to the specific XML format that Access wants to see.
A basic Table of orders be something like the attached XML file.
This file imports into MS Access with no issues (accepting all of the Imports Wizard's default settings)
JeffCoachman
tblOrders.xml