OT: Access & XML friendly with each other?

[AMF]

Does anyone out there know if Microsoft Access can export and import XML data files without too much trouble?

Thanks,

Alarik

[Ed Kolis]

Yes, just select the table you want to export, then pick Export from the file menu; XML is the second to Last file type on the list. (At least it is in Access 2002 - I don't know if your Version supports XML.)

To import, just use File, Get External Data, Import, and like before select XML from the dropdown. Easy as pie!

If you want to get fancy you can write a program using ADO.NET to load the data into a dataset and do whatever you want before you export/import it, since ADO.NET supports both Access and XML, which is in fact its native format

Is this for a SE4-related project?

[AMF]

Thanks! No, it's not for SE4, it's potentially for work...

Originally posted by Ed Kolis:
Yes, just select the table you want to export, then pick Export from the file menu; XML is the second to Last file type on the list. (At least it is in Access 2002 - I don't know if your Version supports XML.)

To import, just use File, Get External Data, Import, and like before select XML from the dropdown. Easy as pie!

If you want to get fancy you can write a program using ADO.NET to load the data into a dataset and do whatever you want before you export/import it, since ADO.NET supports both Access and XML, which is in fact its native format

Is this for a SE4-related project?