HomeForum
Welcome, Guest

Mapping XML to EXCEL
(1 viewing) (1) Guest
  • Page:
  • 1

TOPIC: Mapping XML to EXCEL

Mapping XML to EXCEL 1 year, 2 months ago #1774

  • philippe
  • OFFLINE
  • Fresh Boarder
  • Posts: 4
  • Karma: 0
Hi all

I have several XML files and I would like to load all of them into to one excel sheet.
I mapped one XML file to the excel shit and created a project from it.
How can I run it on all the others XML files without open one by one?

Thanks
Philippe

Re: Mapping XML to EXCEL 1 year, 2 months ago #1777

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2181
  • Karma: 12
Have a look at this tutorial

You can use simple principle to load data fro several XML files
www.dbsoftlab.com/online-tutorials/advan...o-ms-sql-server.html

Mike

Re: Mapping XML to EXCEL 1 year, 2 months ago #1778

  • philippe
  • OFFLINE
  • Fresh Boarder
  • Posts: 4
  • Karma: 0
But this demo is about processing CSV files not XML

Philippe

Re: Mapping XML to EXCEL 1 year, 2 months ago #1779

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2181
  • Karma: 12
Same principle applies to XML

Look at the attached picture

note *.XML <=this mask
this mean that all files with XML extension from C:\support\ directory will be processed

Mike
xml.GIF
  • Page:
  • 1
Time to create page: 0.16 seconds

Testimonials

"Pricing is an important aspect of our software investment program and DBSL exceeded our expectations in both performance and value for money."

Dana Sander,
ICT Manager

User Login

You only need to log in or register to use our support forum



Our customers

BP

BBC

HSBC


Databases we work with

Go to top