>Hi All,
>
>I need to export some records from multiple tables to a XML file, then import them to a SQL Server 7 database (using another standalone small app written in VB/VFP or whatever). The file can be saved to a floppy or sent by eMail to the central office where the SQL Server resides.
>

Is there a reason you specifically want to use XML?

Are the source tables VFP tables?

If the import program can be VFP, why not just use VFP tables? you don't even need offline views if you have control over server side processing. You can just write code to open and SCAN the tables, inserting each record in the the SQL database through SPT or remote view, or whatever.

>I'm wondering if using XML will be a waste of time/effort, and if something else can be implemented instead (offline views??). (I tried once to export 3000+ records to XML using MSXML DOM, but the DOM is so sloooow to save/load.)

You're right, XMLDOM is very slow when dealing with this many records, but then again, it's not really designed to do that.