如何将.msgs文件转换为SqlServer 2005 [英] How to Convert .msgs file to SqlServer 2005

问题描述

如何将.msgs文件转换为SqlServer 2005

------------------------------ ----------





亲爱的所有人，



我有一个扩展名为.msgs的文件，对于这个文件我想转换成SQL Server 2005数据库表。



可能这个文件就像IN和OUT框信息展望。



请有人能给我转换这个档案的最佳解决方案。



谢谢。

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.

推荐答案

您要么自己编写代码，要么可以在线搜索可以读取这些类型文件的工具。您可能需要使用Office互操作， http://msdn.microsoft.com/en-us/ library / 15s06t57.aspx [ ^ ]，能够读取它，然后解析它并将其放入SQL中。



希望有一个库可以做到或者如果这是一个复制并粘贴到Sql中可能会更好。

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.

如果Outlook在MS Exchange服务器上存储电子邮件，请看一下：在Exchange Server和SQL Server之间同步Outlook数据 [ ^ ]



在其他情况下，请参阅：GeniusConnect网站 [ ^ ]及其< a href =https://www.youtube.com/watch?v=NAkxO_8vUIc>将电子邮件保存到SQL教程（视频） [ ^ ]。

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)[^].

这篇关于如何将.msgs文件转换为SqlServer 2005的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！