Getting to Know XML - Determining the Form of Your Data
(Page 3 of 4 )
The first step to migrating your data to XML is to determine what form your data is currently in, and then find a solution based off of that. Below I will write a quick guide to determining several forms in which your data may be.
Spreadsheet
If your data is stored in a spreadsheet, you will need to create an XML Schema and then use that Schema to map and connect your spreadsheet to your XML document. I will go over how to do so in a later article.
Database
If your information is in a database, there are several options available to you. You can export your XML document and Schema. You can also export an XLST document to display on the web. You can even use one of several editors, such as XMLSpy, to import and export data from many different types of databases. We will cover this in a later article.
Comma Separated Values or CSV File
If your data is in a comma-separated file, you can use an XML editor to import your information into an XML file. This is also an option for other delimited file types, such as tab delimited and so forth.
