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! http://forum.shrapnelgames.com/images/icons/icon12.gif

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 http://forum.shrapnelgames.com/images/icons/icon6.gif

Is this for a SE4-related project? http://forum.shrapnelgames.com/images/icons/icon12.gif

[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! http://forum.shrapnelgames.com/images/icons/icon12.gif

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 http://forum.shrapnelgames.com/images/icons/icon6.gif

Is this for a SE4-related project? http://forum.shrapnelgames.com/images/icons/icon12.gif <font size="2" face="sans-serif, arial, verdana">