View Single Post
  #3  
Old May 4th, 2004, 04:00 PM

AMF AMF is offline
Lieutenant Colonel
 
Join Date: Dec 2000
Posts: 1,254
Thanks: 0
Thanked 0 Times in 0 Posts
AMF is on a distinguished road
Default Re: OT: Access & XML friendly with each other?

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

Quote:
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?
Reply With Quote