 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Importing / Linking / May 2004Importing XML into a table
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 File | Get External Data | Import, then look for XML in the Files of Type box at the bottom of the dialog.  SignatureDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (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. > Thanks, > Michael 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? The Application object has an ImportXML method that'll let you do it. SignatureDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (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? I am new to Access, can you supply me a code snipit please? Thanks for your time and guidance, Mike P. 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 SignatureDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) > I am new to Access, can you supply me a code snipit please? > > Thanks for your time and guidance, > Mike P. There's also Peter Vogel's Smart Access article at http://msdn.microsoft.com/library/en-us/dnsmart03/html/sa03k8.asp SignatureDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) > Check > http://msdn.microsoft.com/library/en-us/vbaac11/html/acmthImportXML.asp or [quoted text clipped - 7 lines] > > Thanks for your time and guidance, > > Mike P. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.