Classic ASP - import XML file in to MySQL Database

Hi,

I have a folder full of XML files on the web server. I need the latest XML file to be imported into a MySQL database.

I need:

1: The MySQL database table creating, based on the fields in the XML file (I will provide you with the connection details to the MySQL database).

2: An ASP file (in Classic ASP - VBScript) that will scan for the latest file in the specified folder, and will import the XML data in to the MySQL database that you created. Before importing the data, it should remove all existing data.

For someone that works with XML data, this should be a fairly quick and simple job.

I can provide a sample XML file for you to see what sort of data is involved. I would strongly advise asking for this, and I will send it to you as a private message (I would just rather not make this file public).

Please ask if you have any questions.