[AccessD] Importing XML into Access 03 or 07

I dunno...this is why I am asking for help. I thought maybe there was way to automate this process. If I could script the process of hitting "import", choosing the next email message/XML entry, in the directly, then deleting it, it would work great.
 
PS...I haven't been here, since I sent the message, so I apologize for the late response.
 
John W. Clark
Information Technology Technician
Niagara County
Central Data Processing
         


>>> "Charlotte Foust" <cfoust at infostatsystems.com> 9/11/2008 3:22 PM >>>
If you have 250 emails, how would you expect to handle them all at once?

Confused
Charlotte Foust

-----Original Message-----
From: accessd-bounces at databaseadvisors.com 
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Clark
Sent: Thursday, September 11, 2008 12:00 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Importing XML into Access 03 or 07

Our department hosts this Technology & Homeland Security Forum every
year...it is at the Niagara Falls Casino this year, next month. This is
my first year of any involvement other than "one of the department
employees." The woman who did this, in the past, posted a registration
form, on our web site
(http://www.niagaracounty.com/docs/registrationform.pdf) that she
created using "Adobe LiveCycle Designer 8.0" This information is
received by us, usually, via email, in the format of the
following...actually, I'll place it at the end...

Each single email contains XML data for one single user. She was
importing these, somehow, into Excel. Excel would be fine, although, I'd
prefer Access. I know how to import each of these one at a time, but
there are about 250 of these and I'd like to import them all at once if
I could. 

Any ideas?

XML data, in Email follows:

  <?xml version="1.0" encoding="UTF-8" ?>
- (
file:///G:/Tech%20Forum%202007/Final%20Attendee%20Information/Registrati
on%20Forms/deemer.xml# ) <form1>
- (
file:///G:/Tech%20Forum%202007/Final%20Attendee%20Information/Registrati
on%20Forms/deemer.xml# ) <!--
************************************************************************
****** If you filled in a form: This file contains data that was entered
into a form. It is not the form itself.
************************************************************************
****** If you receive this data file: Please follow the directions below
to process this data file using Adobe Acrobat Professional 7 **To view
the completed form: 1) Save this data file to your computer. 2) Open a
blank copy of the original PDF form that the form filler completed in
order to generate this data file. 3) In Acrobat, choose Advanced > Forms
> Import Data to Current Form and browse for this data file. 4) You will
see the form with the data in it. 5) To save a copy of the form with the
data in it, choose File > Save As and save the file. **To create a
spreadsheet from one or more form data files you have r!
eceived: 1) Save the data files to a place on your computer, giving
each file a unique name and making sure not to delete the '.xml' file
extension. 2) In Acrobat, choose File > Form Data > Create Spreadsheet
from Data Files. 3) Click the 'Add Files' button to chose the data
files. 4) After the data files are added, click the 'Create Spreadsheet'
button to create a Spreadsheet that contains data from selected data
files.
************************************************************************
******  -->
  <Name>Tami Deemer</Name>
  <CompanyName>Niagara County Data Processing</CompanyName>
  <Email>tami.deemer at niagaracounty.com</Email>
  <BrightPlanITAM>0</BrightPlanITAM>
  <CiscoAM>0</CiscoAM>
  <IPLogicAM>0</IPLogicAM>
  <NYPAAM>0</NYPAAM>
  <Lunch>1</Lunch>
  <BrightPlanITPM>0</BrightPlanITPM>
  <CiscoPM>0</CiscoPM>
  <IPLogicPM>0</IPLogicPM>
  <NYPAPM>0</NYPAPM>
  <NYSA>0</NYSA>
  </form1>


John W. Clark
Information Technology Technician

Niagara County
Central Data Processing
         
--
AccessD mailing list
AccessD at databaseadvisors.com 
http://databaseadvisors.com/mailman/listinfo/accessd 
Website: http://www.databaseadvisors.com 

-- 
AccessD mailing list
AccessD at databaseadvisors.com 
http://databaseadvisors.com/mailman/listinfo/accessd 
Website: http://www.databaseadvisors.com