We help IT Professionals succeed at work.

MS Access 2003 - Read XML from attached Groupwise emails

Lou Dufresne
Lou Dufresne asked
on
Medium Priority
379 Views
Last Modified: 2012-06-22
I receive Groupwise emails with an attached XML data. The emails are placed into one subdirectory with the XML data Attachment.  I would like to just read the XML data into a MS Access table from each email received without having to detach the XML data from each email and import each separately in to my Access table.  The attached XML file is always the same name.  

I know this may be difficult so any guidance in the right direction would be appreciated.


Lou

Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2006
Commented:
It may be possible, if u have a .xml file, to use the feature available in A2003?

Application.ImportXML

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Leigh PurvisDatabase Developer
CERTIFIED EXPERT
Commented:
I think you have several problems (not using Groupwise myself can't be sure).

You need to get at the content of the email attachments.
In Outlook automation would likely help there - but even then I'd imagine that would involve using automation to save the file to a location in code and then reading from that file?
Then if the XML was particularly friendly and predictable - as Rocki says you might get away with doing a direct XML import using built in functionality.
If it is predictable - but not very congruent with your existing tables - you could always import to a temporary storage table - then run insert statements from there to your real table.

That would likely still be easier than opening the XML directly and parsing through it with an XML parser (amazing huh - who'd have thought you'd use an XML parser to parse XML... damn I'm good  :-S).

See - from where I'm coming from the second bit is easier, because I don't know Groupwise or how controllable it is (via automation/command line/whatever).
If that's doable - the whole thing should be just fine.
Lou DufresneScrum Master / Technical Business Analyst

Author

Commented:
Thanks all for your guidance.


Lou
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.