Thread
:
OT: Access & XML friendly with each other?
View Single Post
#
3
May 4th, 2004, 04:00 PM
AMF
Lieutenant Colonel
Join Date: Dec 2000
Posts: 1,254
Thanks: 0
Thanked 0 Times in 0 Posts
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?
__________________
Haro!
A great place to send your money
AMF
View Public Profile
Send a private message to AMF
Find all posts by AMF