Importing XML into a table

[Mike P]

I was able to write code to generate an XML file from a table. Can someone tell me how to now import the XML file back into a table? I am using Access 2003 and am new to Access

Thanks
Michae

 

[Douglas J. Steele]

File | Get External Data | Import, then look for XML in the Files of Type
box at the bottom of the dialog.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I was able to write code to generate an XML file from a table. Can

someone tell me how to now import the XML file back into a table? I am
using Access 2003 and am new to Access.

 

[Mike P]

I was hoping to control the Import myself from a control button inside my access program. I'd like to use access programming to handle the import. Any ideas?

 

[Douglas J. Steele]

The Application object has an ImportXML method that'll let you do it.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I was hoping to control the Import myself from a control button inside my

access program. I'd like to use access programming to handle the import.
Any ideas?

 

[Mike P.]

I am new to Access, can you supply me a code snipit please?

Thanks for your time and guidance,
Mike P.

 

[Douglas J. Steele]

Check
http://msdn.microsoft.com/library/en-us/vbaac11/html/acmthImportXML.asp or
the Help file.

You can also see what Danny Lesandrini wrote about it in Smart Access at
http://msdn.microsoft.com/library/en-us/dnsmart02/html/sa02a1.asp

 

[Douglas J. Steele]

There's also Peter Vogel's Smart Access article at
http://msdn.microsoft.com/library/en-us/dnsmart03/html/sa03k8.asp