Import Outlook/ACT etc contacts to SQL Server table

Guys
Does anyone know of a 3rd party module/plug-in for VS or even some
downloadable code that enables the import of Outlook/ACT and similar contact
information through an ASP.NET page into a SQL Server table with ongoing
1-click button sync.

I need to replicate something similar to the Intellisync tool used in Yahoo
Mail.

regards
AndyOutlook OWA is implemented with RPC(Remote Procedure Call), ANSI SQL has been on RPC since 1969 so if you look into .NET System .NET which deals with Networking and Sockets you can write the code. In C# The complete reference has a chapter on System .NET. I would also run a search on MSDN for OWA Web implementation sample code. SQL Server Ports are TCP 1433 and UDP port 1434. Hope this helps.

Kind regards,
Gift Peddie|||Andy,
I need to do the same thing. Maybe we can team up on something?

ScAndal|||Similar thread:http://forums.asp.net/thread/44602.aspx

Import Data from ACT to SQL

I am releasing my CRM application today and I have one more task to accomplish by months end. I need to import all of our data from ACT into SQL. If you know anything about ACT, it uses a flat table in DB2 or DB5. My new application uses SQL Server with normalized tables. How can I import this data and map it properly to my SQL tables? As a side note, all the ACT data has been exported to an Access table, perhaps it is easier to use it rather than the ACT DB. So I have two options available.

Thanks.PD,
Did you have any luck with this? I need to do the same thing.

ScAndal|||been quite awhile since i played with ACT, but i think there is a driver that will read those files. you may have to export out of ACT first. DTS would be your best option. I would read the files into holding tables and then develop some intermediate tables that map up to your SQL tables. then you would just need to write the various selects and updates to force the data into your new model before doing your final import. it's kind of a typical data scrubbing type app. the nice thing is if you can get the DTS package working, you could reimport multiple times if necessary.

cs|||I ended up importing the ACT data to Excel, cleaned it up and then built a DTS pkg to pull it to my tables.