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)

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

No comments: