Dynamically import Outlook .pst file into table

microsoft.public.sqlserver.programming

28 Jul 2006 2:30 AM

Sandy

Hello -

Our organization has an up-to-date Outlook .pst file that lists all users,
first name and last name, and their Windows user names in our area. I need a
list of all users and user names in a table in my Sql Server 2000 database.
Providing my organization allows me to do so, is there a way to dynamically
import .pst files into my table? I'm looking for some sort of example code.

Any help will be greatly appreciated!

--
Sandy

28 Jul 2006 3:35 AM

Immy

Not sure how dynamic you can make this, but you could export your pst file
via outlook into a csv, excel file type etc and then import the file into
SQL server using DTS.

The import mechanism could be done dynamically, but not sure about the
export process.

Immy

Show quote

"Sandy" <Sa***@discussions.microsoft.com> wrote in message
news:63D03BC3-8636-4D5B-BB8D-DAC4C566929C@microsoft.com...
> Hello -
>
> Our organization has an up-to-date Outlook .pst file that lists all users,
> first name and last name, and their Windows user names in our area. I
> need a
> list of all users and user names in a table in my Sql Server 2000
> database.
> Providing my organization allows me to do so, is there a way to
> dynamically
> import .pst files into my table? I'm looking for some sort of example
> code.
>
> Any help will be greatly appreciated!
> --
> Sandy