ETL and Data Integration tools - Modern ETL software for everyone
Home
Products
Overview
Advanced ETL Processor
Advanced ETL Processor Pro
Advanced ETL Processor Ent
Visual Importer
Visual Importer Pro
Visual Importer Ent
Data Exchange Wizard
ABI Portal
Active Table Editor
VImp X
DEWizardX
Database Browser
Table2Text
QlikView Connector
Support
Support Procedure
Support Forum
Partners
Partnership Options
Register as a Partner
Partner Login
Software Distribution
Order
Online Shop
Ordering Software
Customer Care Center
Articles
Downloads
Contact Us
Questions? Call us today: +44 (0) 843 289 2768
Home
Forum
Index
Recent Topics
How to get Help today
Search
Welcome,
Guest
ETL-Forum
Forum
Advanced ETL Processor
Mapping XML to EXCEL
(1 viewing) (1) Guest
Reply Topic
New Topic
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
Reply
Quote
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
Reply
Quote
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
Reply
Quote
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
Reply
Quote
Reply Topic
New Topic
Page:
1
ETL-Forum
Forum
Advanced ETL Processor
Board Categories
Forum
... Data Warehousing and Data integration
... Advanced ETL Processor
... Visual Importer
... Database Browser
... Active Table Editor
... Active Table Editor
... All other ETL and ActiveX Products
... The Suggestion Box
... Independent Consultants
Powered by
Kunena
Online Data transformation tutorials
Converting text files using
Loading data from multiple files into MS Sql Server
Performing Star Transformation
Working with Pivot and Sorter
Exporting data from MySQL Database into text files
Loading Data from Excel file into MySQL Database
ETL News
Loading data from RSS feeds
Automating loading QlikView dashboards in distributed environment
Union ALL Data transformation
Loading data from QVX files
Advanced ETL Processor - Themes
New data transfornation functions
Select Language
English
Arabic
Bulgarian
Chinese (Simplified)
Chinese (Traditional)
Croatian
Czech
Danish
Dutch
Finnish
French
German
Greek
Hindi
Italian
Japanese
Korean
Norwegian
Polish
Portuguese
Romanian
Russian
Spanish
Swedish
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
Username
Password
Remember Me
Forgot your password?
Forgot your username?
Create an account
Our customers
Go to top