Solved

MS Access 2003 - Read XML from attached Groupwise emails

Posted on 2006-10-24
3
353 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

0
Comment
Question by:Lou Dufresne
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 65

Accepted Solution

by:
rockiroads earned 300 total points
ID: 17795433
It may be possible, if u have a .xml file, to use the feature available in A2003?

Application.ImportXML
0
 
LVL 44

Assisted Solution

by:Leigh Purvis
Leigh Purvis earned 200 total points
ID: 17809895
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.
0
 
LVL 1

Author Comment

by:Lou Dufresne
ID: 17841436
Thanks all for your guidance.


Lou
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question