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 |
|
dovobez
Starting Member
2 Posts |
 Posted - 2009-11-01 : 13:21:32
|
| I have created Tables containing data on a SQL Server Database, (NOt COmpact). What I now wish to do is to export that data so that I can create a contact in outlook with it, or simply output the data to email. Can anyone provide any help on this, i would really appreciate this:)CheersKnowledge is Power, but power isnt always knowledge |
|
|
masterdineen
Aged Yak Warrior
550 Posts |
Posted - 2009-11-02 : 03:35:31
|
| Hello DovobezThis may be a long way around but i would suggest saving sql server data to csv file ie (excel) thenimporting your contacts into outlook using the csv file. At the moment i dont know a quicker way of doing this. I should imagine you could do this using SSIS. But for a one off just use the SSMS wizards.Kind RegardsRob |
 |
|
|
dovobez
Starting Member
2 Posts |
Posted - 2009-11-02 : 05:17:45
|
| Hi MasterdineenI had thought of this too but I dont see the difference from reading a csv or a SQL database. because it is a project im working on, i am trying to actually implement it rather than use the wizard.Knowledge is Power, but power isnt always knowledge |
|
|
|
masterdineen
Aged Yak Warrior
550 Posts |
Posted - 2009-11-02 : 05:31:53
|
| have a look at this you never knowhttp://msdn.microsoft.com/en-us/library/aa155737(office.10).aspxMCTS certified |
|
|
|
masterdineen
Aged Yak Warrior
550 Posts |
Posted - 2009-11-02 : 06:06:32
|
| i would have a look at ssis for good automation.MCTS certified |
|
|
|
|
|
|
Import data from SQL Server DB to Outlook