Mapping Outlook Fields to SQL

  • Thread starter Thread starter Dave F
  • Start date Start date
D

Dave F

Before I start this process, I wanted to see if any one has already done it.

I need to get Outlook data into SQL Server and there are 141 standard fields
in Outlook.

Has anyone created a CREATE TABLE script will map the standard fields and
their data types to a SQL Server table?

I can bring them into SQL Server using DTS and create a table on the fly but
the resulting fields are all datatype nvarchar(255). I am looking for a
more accurate mapping of datatytpes and was hoping someone who has already
done this would be willing to share their work.



Also, is there a fast way to get a mapping of VBA object names to Outlook
field names?

For example, the Outlook field "company" is referenced in VBA as
"Outlook.ContactItem.CompanyName."

Is there a convenient listing of all these VBA referernces ("company" =
"companyname")
 
Dave said:
Before I start this process, I wanted to see if any one has already done it.

I need to get Outlook data into SQL Server and there are 141 standard fields
in Outlook.

Has anyone created a CREATE TABLE script will map the standard fields and
their data types to a SQL Server table?

I can bring them into SQL Server using DTS and create a table on the fly but
the resulting fields are all datatype nvarchar(255). I am looking for a
more accurate mapping of datatytpes and was hoping someone who has already
done this would be willing to share their work.



Also, is there a fast way to get a mapping of VBA object names to Outlook
field names?

For example, the Outlook field "company" is referenced in VBA as
"Outlook.ContactItem.CompanyName."

Is there a convenient listing of all these VBA referernces ("company" =
"companyname")
Click to expand...


--
---------------------------------
Trevor Lowing
Satellite Beach, Fl

(e-mail address removed)
---------------------------------
Need help with:
Access?
http://www.mvps.org/access/
Outlook?
http://www.slipstick.com/
Visio?
http://www.mvps.org/visio/
HTML/CSS?
http://www.NCDesign.org
Scripting(VBScript/JScript/WSH/XML)?
http://www.DevGuru.com
http://cwashington.netreach.net/
http://developer.irt.org/script/script.htm
---------------------------------
 
Hmm.....I don't get it.

Are you referencing the links below your signature?

I tried seraching on "datatypes" at SlipStick and got:

Search Results
Your search for datatype did not return any matches (472 documents were
searched)

Moving data from Exchange to SQL Server has to be a common task. I just
thought someone would have already tackled this issue.

Dave
 
Whoops

Okay, I do get several hits with "data type" rather than "datatypes"

But I'm still not seeing what I need.
 
Sorry about that. Fat Fingers. I thought I had given you a list of
object model references and similar efforts:

http://www.outlookcode.com/d/database.htm

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsmart00/html/sa00h12.asp

(see reference section)
http://msdn.microsoft.com/library/en-us/exchanchor/htms/msexchsvr_mapi.asp?frame=true


Object Model Stuff

http://support.microsoft.com/default.aspx?scid=kb;EN-US;222101

http://www.microsoft.com/downloads/...80-23e2-456f-8618-4da50cc2c38c&DisplayLang=en

http://www.microeye.com/resources/ObjectModel2003.htm



Code Examples

http://support.sas.com/rnd/eai/samples/OutDataExtract/index.html

http://www.emsonnet.com/c5/O1/C1211.html

http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Providers.htm#OLEDBProviderForExchange

http://www.w3.org/2000/10/swap/pim/lookout.py




---------------------------------
Trevor Lowing
Satellite Beach, Fl

(e-mail address removed)
---------------------------------
Need help with:
Access?
http://www.mvps.org/access/
Outlook?
http://www.slipstick.com/
Visio?
http://www.mvps.org/visio/
HTML/CSS?
http://www.NCDesign.org
Scripting(VBScript/JScript/WSH/XML)?
http://www.DevGuru.com
http://cwashington.netreach.net/
http://developer.irt.org/script/script.htm
---------------------------------
 
Back
Top