Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Use SQL*XL to query XML files from Excel (Read 5582 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Use SQL*XL to query XML files from Excel
24.03.06 at 16:06:11
 
It is possible to query XML files from Excel. SQL*XL can "connect" to an XML file and retrieve data from the XML file with SQL. SQL*XL was tested to use the freeware viksoe.dk OLE DB provider for XML.  
 
For more information please see:
SQL*XL user question on how to retrieve XML data into Excel.
http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1143211876
Freeware viksoe.dk OLE DB provider for XML:
http://www.viksoe.dk/code/xmloledb.htm
You will need the MSXML 4.0 software from microsoft which can be downloaded at:
http://www.microsoft.com/downloads/details.aspx?familyid=3144b72b-b4f2-46da-b4b6 -c5d7485f2b42&displaylang=en
(http://msdn.microsoft.com/xml)
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1