What's the best way of doing this?
The XML file is written using the ADO recordset Save method and can obviously be read back in using the Open method.
Now picture this. You have 2 databases of the same structure and compatible data types. One on SQL server and one in Access. You create the XML file from the Access database, and want to put it into the SQL server. When you open the XML file using the open method how do you then write that recordset to the database. would you have to loop thorugh the records and insert or is there a sort of 'batch insert' way of doing it?
and I guess ... is XML the best way of doing this? The system I'm working on currently has two options. write the recordset into a separate, smaller database then just read it record by record back into the SQL server. The other is write it to a formated, non delimited text file that then gets read, line by line into the database.
I'm just wanting a faster method of processing this. SQL packages from the source to the destination is not an option as the source would be at a client site and the SQL server is on site here.
Enter your message below
Sign in or Join us (it's free).