.PST to SQL

Dear all,
Does anyone know how to migrate .PST files into Sql Server? Is there any
odbc, driver or something like that?
I think that in sql2k there was no like that but I was wondering about Sql25
k
Thanks for any suggestion,
Please post DDL, DCL and DML statements as well as any error message in
order to understand better your request. It''s hard to provide information
without seeing the code. location: Alicante (ES)That's an Outlook Personal Folder file, right?
Within Outlook, if you select "Export to a File", there are options to
export to delimited text, MS Access or MS Excel, which can be more readily
imported using Enterprise Manager or DTS.
If you are an application developer, there is an ADO and ADO.NET provider
for Exchange Server. Other APIs for programatically getting messages from
Exchange Server or Outlook are OLE Automation, CDO, and WMI:
http://www.microsoft.com/technet/sc...ap.msp
x
"Enric" <vtam13@.terra.es.(donotspam)> wrote in message
news:668DABFB-6FCB-46FE-B8F8-34176E22D587@.microsoft.com...
> Dear all,
> Does anyone know how to migrate .PST files into Sql Server? Is there any
> odbc, driver or something like that?
> I think that in sql2k there was no like that but I was wondering about
> Sql25k
> Thanks for any suggestion,
> --
> Please post DDL, DCL and DML statements as well as any error message in
> order to understand better your request. It''s hard to provide information
> without seeing the code. location: Alicante (ES)|||i would suspect the best way is to do an export to csv from outlook,
then use bcp or bulk insert, unless you have a lot of them to do.|||Thank a lot both
--
Please post DDL, DCL and DML statements as well as any error message in
order to understand better your request. It''s hard to provide information
without seeing the code. location: Alicante (ES)
"Johnny D" wrote:

> i would suspect the best way is to do an export to csv from outlook,
> then use bcp or bulk insert, unless you have a lot of them to do.
>