Click here to Skip to main content
15,891,907 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
How to Convert .msgs file to SqlServer 2005
----------------------------------------


Dear All,

I have a file with extension .msgs, For this file i want to convert into SQL Server 2005 database table.

May be this file is like IN and OUT box messages outlook.

Please can anybody can give me the best solution to convert this file.

Thanks.
Posted

You'll either have to write the code yourself or perhaps search online for a tool that can read those types of files. You may need to use the Office interop liraries, http://msdn.microsoft.com/en-us/library/15s06t57.aspx[^], to be able to read it and then parse it and put it into SQL.

Hopefully there is a library to do it or if this is a one time thing you may be better off copying and pasting right into Sql.
 
Share this answer
 
Comments
Maciej Los 28-Apr-14 15:53pm    
+5PLease, see my answer ;)
If Outlook stores emails on MS Exchange server, please, have a look here: Synchronizing Outlook Data between Exchange Server and SQL Server[^]

In other case, please see: GeniusConnect site[^] and its Save email to SQL tutorial (video)[^].
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900