Thursday, February 17, 2011

Creating SQL Statements from an XML File

I worked up an XSL Stylesheet to transform a two-column Excel file into a SQL Update Statement.

Here is my order of events:

I saved the Excel File as a .csv file.

I used creativyst.com to change the .csv to an XML file.

I put a XML header on the file:

I saved the XML file to a web server where I could access it with a URL.

I used PORDL to create a new feed transform with the following XSL:



The output was a clean SQL Update Statement I could use to do a mass update of records on an OsCommerce database.

No comments:

Post a Comment