HamotIntern
MIS
I realize what I am going to say will not make a lot of sense why I want to do this, but after I gave you long explanation, it would.
I want to put a number of NON-SQL tables into XML documents. Then, I want to inert the data from the XML documents into existing SQL tables. The format of the tables is identical; in fact, the NON-SQL tables are a more up-to-date version of the ones currently on the SQL Server.
The method I have tried so far is rst.Save "C:\filename.xml", 1 'adPersistXML to import the table into XML & Bulk Load to put the data into a SQL table. However, recordset.Save does not create the XML document in a way that Bulk Load can use it, (at least as far as I know).
Any ideas?
I want to put a number of NON-SQL tables into XML documents. Then, I want to inert the data from the XML documents into existing SQL tables. The format of the tables is identical; in fact, the NON-SQL tables are a more up-to-date version of the ones currently on the SQL Server.
The method I have tried so far is rst.Save "C:\filename.xml", 1 'adPersistXML to import the table into XML & Bulk Load to put the data into a SQL table. However, recordset.Save does not create the XML document in a way that Bulk Load can use it, (at least as far as I know).
Any ideas?
