You need to process the XML file using a XML parser. Here you have two options: 1. DOM 2. SAX You can find lots of DOM or SAX parsers to work with from ASP or JSP. If I were you I would work with JSP. Once you have the DOM structure (which is a tree with all data from the XML file), just extract the data and post them to SQL table using JDBC.