Sunday, April 04, 2010

XML Importing Into Access

Albert Kallal has posted sample code for Importing XML into Access (if the Access importing falls short of the mark)
http://www.utteraccess.com/forum/Xml-Sql-Put-Code-t1940040.html

BTW. Access Importing Rules Of Thumb

  • if it imports then Access is a great tool.
  • If it doesn't then watch out as it could be tricky.
  • XML Notepad is a great free editor from Microsoft.
  • When importing, you may need to use temp tables
  • Make sure that your primary keys stop multiple imports from duplicating data
Garry

No comments: