How to create MDF file (.mdf) file from XML file.

[Dave]

Hi,

I have an xml file which is a backup of a SQL 2000 Database Table. I
would like to create an .mdf file for use with SQL Server Express on
my local home machine. How do I create a .mdf file from a xml file?
I looked for option is SQL Server Management Studio Express and Visual
Studio without success.

Any tutorial/samples/references available?

Thanks,

Dave

[Juan T. Llibre]

Even though the techniques described at :
http://www.perfectxml.com/articles/xml/importxmlsql.asp
....are for SQL Server 2000, you can use them in SQL Server Express.


Juan T. Llibre, asp.net MVP
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en español : http://asp.net.do/foros/
======================================
"Dave" <cs********@hotmail.comwrote in message
news:11**********************@z28g2000prd.googlegr oups.com...

Hi,

I have an xml file which is a backup of a SQL 2000 Database Table. I
would like to create an .mdf file for use with SQL Server Express on
my local home machine. How do I create a .mdf file from a xml file?
I looked for option is SQL Server Management Studio Express and Visual
Studio without success.

Any tutorial/samples/references available?

Thanks,

Dave