By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,471 Members | 711 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,471 IT Pros & Developers. It's quick & easy.

OutLook Exchange Server and SQL

Nauticalgent
P: 92
Quick question but some background first.

I use MS Access with SQL Server as my BE (tables). The main source of my new and updated records come from a linked Outlook Public Folder which get parsed with Access and then "stuffed" into their respective tables.

Although this method works, it has become slow and seems a bit cumbersome.

Is there a way to link the OL Folder directly to SQL?

Thanks in advance!

John
Jul 27 '18 #1
Share this Question
Share on Google+
2 Replies


zmbd
Expert Mod 5K+
P: 5,397
Nauticalgent:
I remember seeing something about this in one of the programing for Outlook books at Barnes-And-Noble ages ago; however, at the time it wasn't something I was doing so I didn't study the code or concepts - I didn't buy the book either.

What I do remember is that it used a ADODB connection

Quick query turns up a generic Con

Expand|Select|Wrap|Line Numbers
  1. sConnString = "Provider=SQLOLEDB;Data Source=INSTANCE\SQLEXPRESS;" & _ 
  2.    "Initial Catalog=YourSqlDataBaseNameHere;" & _
  3.    "User ID=YourUserNameHere;Password=YourPassWordHere;"
  4.  
If you google search on "Outlook ADODB Connection" it turns up a lot of different ideas.

Just a bit out of my depth interfacing Outlook-Exchange to SQL-Server

-Z
Jul 28 '18 #2

Nauticalgent
P: 92
Z,

I was hoping you would see this and weigh in. You seemed to have a good understanding of OL Folders from a previous thread and I figured you might have something to offer.

The ADODB connection makes sense because everything I have read about SQL talks about how ADO is better suited for SQL Server than DAO.

I found the same results you did with a Dr Google consult session but before I’m chase that rabbit down the hole, I wanted to see if anyone else had also.

Thanks for the reply.

John
Jul 28 '18 #3

Post your reply

Sign in to post your reply or Sign up for a free account.