Subject:Is it possible to create xml file using existing schema and xls file as database source Author:Minollo I. Date:06 Aug 2008 03:32 PM
Using our DataDirect XML Converters and XQuery components you will be able to do that only if you save the Excel file as .csv (Comma Separated Value file) or .slk (Symbolic Link); then you can use XML Converters to interpret the file as XML and XQuery to shape it according to your pre-existing XML Schema.
Subject:Is it possible to create xml file using existing schema and xls file as database source Author:Ed J Date:08 Aug 2008 01:08 PM
The XML is a new thing for me. Therefore just to make sure I understand the overall concept. The xls file (or any other file, flat files, etc) 1st have to be converted to XML format (this mean that tags for every field in all records) in order to be used in the XQuery. Is this is correct.
Subject:Is it possible to create xml file using existing schema and xls file as database source Author:Minollo I. Date:08 Aug 2008 01:33 PM
>The xls file (or any other file, flat files, etc) 1st have to be
>converted to XML format (this mean that tags for every field in all
>records) in order to be used in the XQuery. Is this is correct.
It is correct.
>Also how to you save xls in the .xlsx format?
Using Excel 2007, Save As... > Save as type "Excel Document (*.xlsx)"