Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 351
  • Last Modified:

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?
0
Buck_Beasom
Asked:
Buck_Beasom
  • 4
  • 3
1 Solution
 
Jeffrey CoachmanMIS LiasonCommented:
Post a sample of the xml file.
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
0
 
Buck_BeasomDatabase DesignerAuthor Commented:
I've requested that this question be deleted for the following reason:

I cannot post the requested file because it is confidential company information.
0
 
Jeffrey CoachmanMIS LiasonCommented:
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
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
Buck_BeasomDatabase DesignerAuthor Commented:
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.
0
 
Jeffrey CoachmanMIS LiasonCommented:
<If you are a regular follower of this site... >
Since 2004 buddy...
;-)

<...you are well aware that I happily pay 500 points for answers to the most rudimentary questions>
Points do not matter to me, I have enough...
;-)

Feel free to check my profile you will see that I am one of the few Experts that regularly post fully functional database files.
Again, my sample was just exploratory.

I used my same file and scaled the number of record up to 1,231,988 (much more than 10's of thousands) records and 125 fields, ...and it all imported into a single table with no problems.

Typically with xml files, ...if it works with 10 records, it will still work with 10,000 records.
Because it's the "format", (not the number of records) that matters.

Sorry you could not get the solution you were looking for.
No issue with you deleting the Q if you did not get an applicable solution.

JeffCoachman
0
 
Buck_BeasomDatabase DesignerAuthor Commented:
I have no problems with this either way.
0
 
Jeffrey CoachmanMIS LiasonCommented:
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
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

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