Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
robert693
Starting Member
42 Posts |
 Posted - 2010-09-29 : 08:58:20
|
| Hello,I have an SQL Server DB that has data, dates and time, that we would like to put into the MS Outlook calendar. What would be the best way to do this? Is there some site that has an explanation? Thank you for all of your help!! |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2010-09-29 : 09:54:30
|
| You can export SQL Server data to comma-separated or tab-separated files and import them directly into Outlook. Use the bcp command-line utility to export (example):bcp "select emailaddress, firstname, lastname from myDB.dbo.myContacts" queryout myContacts.csv -Sservername -Uusername -Ppassword -c -t","Check SQL Server Books Online for more details, and check the Outlook help file for "Import/Export" details. |
 |
|
|
|
|
|
Pull data from SQL Server DB into Outlook