Importing XML files generated from email to SQL Server 2005

Closed Posted Aug 26, 2008 Paid on delivery
Closed Paid on delivery

Hello All,

I recently had a freelancer import data from Outlook to MS Access via ODBC. Once the data is in Access it will be parsed out into varies tables and fields. The problem with that method is that there’s a lot of guess work and assumptions with the data. Therefore the freelancer proposed that parsing data (email) would be better performed via XML method. Therefore this why I’m posting this project, because I want a better way to accomplish my goals.

The original source of the emails is a webmail. I normally access it thru Outlook 2003. The connection specification will be provided to the selected vendor/freelancer…

? Along with this posting are the following:

-? ? ? ? ? ? ? ? ? Samples of the XML format taken from Outlook and Webmail

-? ? ? ? ? ? ? ? ? The Access DB that contains previous work done to my project ?

? **What I want:**

Is to have the email to be converted to an XML format and parsed out into a SQL Server 2005 database.

Please take a look at the Access database because the tables and the fields should also be in the SQL server 2005 database, with few exceptions. Some of the tables in the database are duplicated; which should be merged into one, if possible.

I want one process for the four different XML files!

Please create/program your process to be able to process any email!

**Compensation:

**I will pay a **35%** bonus to the selected vendor/freelancer who finishes the project ON TIME!!!

**Caution!!!**

Please do not wait until the last minute to let me know you are having technical difficult or that you are unable to complete the project.

Whoever places a bid on this project, I want to talk to you to make sure you understand the project, so therefore please provide contact information. If I cannot contact your bid will not be considered!!!

PHP XML

Project ID: #3171311

About the project

2 proposals Remote project Active Sep 7, 2008

2 freelancers are bidding on average $106 for this job

jawadh

See private message.

$106.25 USD in 5 days
(83 Reviews)
6.0
vbguru1vw

See private message.

$106.25 USD in 5 days
(1 Review)
1.1