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.

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.)

Thanks in advance!

Nelson