Solved

Sync Contacts Data - Outlook - MYSQL Database

Posted on 2010-08-17
4
670 Views
Last Modified: 2013-12-13
How can I sync my OUtlook Contacts Data to a MYSQL database?
0
Comment
Question by:Starquest321
[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
4 Comments
 
LVL 8

Expert Comment

by:kingjely
ID: 33461966

You could  
Export your contacts to a .csv file, then import them into outlook


In mysql you can use SELECT INTO OUTFILE


select * INTO OUTFILE
'Drive:/path/contacts.csv'
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\r\n'
from ContactsTable;

Then import to outlook

Kj
0
 

Author Comment

by:Starquest321
ID: 33461979
Actually I need the other way around. . . and would love to have the ability to "sync"
0
 
LVL 8

Accepted Solution

by:
kingjely earned 500 total points
ID: 33462009
Ahh sink Too.. sorry

Aww sure, sorry, miss read that ;)


The other way round..


Export from (Comma Seperated values)
SAVE TO>  c:\contacts.csv

You will then need to

create table to hold the columns


Then in mYsql Browser

load data local infile
"drive:/path/contacts.csv"
INTO TABLE tablename
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\r\n';

if you have a heading in line (1)one which you dont need, add

load data local infile
"drive:/path/contacts.csv"
INTO TABLE tablename
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\r\n'
Ignore 1 lines;

Someone may have a better idea of how to sync, if thats what you need, but hopefully that can get you started ;)

Kj
0
 
LVL 8

Assisted Solution

by:kingjely
kingjely earned 500 total points
ID: 33462035
0

Featured Post

Get Actionable Data from Your Monitoring Solution

Your communication platform is only as good as the relevance of the information you send. Ensure your alerts get to the right people every time with actionable responses. Create escalation rules that ensure everyone follows the process and nothing is left to chance.

Question has a verified solution.

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

This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
If you troubleshoot Outlook for clients, you may want to know a bit more about the OST file before doing your next job. IMAP can cause a lot of drama if removed in the accounts without backing up.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

689 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