import from xml file to query

[dreamdelerium]

hey guys, was wondering if someone can help. heres the scenario: im creating an application that will be used my many computers in an office. because the office is not networked im creating a import/export form that will export a table to an xml file. then that file can be brought to another computer where it will be imported. im trying to figure out the best way to do this. i think it would be best to export a querry to xml file (which i can do) but how do i import it back into a query.

 

[Guus2005]

Can't tell. If you use a csv file exporting and importing are easy. Never worked with XML b4.

 

[Guus2005]

No need to send me a pm. Just continue the thread.

Right click on the tables in the database window. Select Import. Choose filetype: csv, select csv file. You can set the rest of the variables, you can save the settings by clicking ADVANCED or you can end it by clicking FINISHED.

Enjoy!