There are several ways to do that. In case of big amount of data, like in
your case, you could use SQL DTS COM library to do that. But it requires
license for SQL Server. DTS allows to transfer data between different data
sources and work fast.
Another way (but it will be slow) is to save XML file, as you did right
know. But if you need to save that information into another database, then
it requires some chages in XML. If you need example how to use that
technique, then let me know by-email and I will send you example how to
*switch* recordset from one database to another one. It is oo big to post it
> I am using ADO 2.6 SAVE method to export a table in XML format.
> Now I need to import it in another database. How Can I do It? Is there a
> Load xml file? The files are huge. The small one has 318MBytes. I tried
> XMLBulkLoad but the XML generated by ADO Save method is incompatible.
> I have to change most of it in order to run.
> Saving this 318MBYtes table took less than 8 minutes.
> If there is a ADO Load method would it be as eficient? If not please
> suggest me a better way to export and import XML files.
> Best regards,