We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now

x

Importing XML data into Excel

Medium Priority
1,441 Views
Last Modified: 2012-06-27
Hi there,

I am having difficulties importing XML data into excel in one go.

There are around 25000 records and 30 columns, howver when I try to import the data in one go i get the below error:

no data was imported or only some of the data was imported

To overcome this i break the xml file into roughly half the size and import this into excel without any problems. Is there any way i can actually import all the xml data in one go as there will always be 25000 or less records and 30 columns.

Regards,

Bob

Comment
Watch Question

MIS Liason
CERTIFIED EXPERT
Most Valuable Expert 2012
Commented:
Can you post the XML that does not work, and the XML that does work, for comparison purposes?

Another option would be to import the XML data to MS Access first, then export from Access to Excel.

JeffCoachman

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.