import access odbc linked table to outlook

[Jeff]

Instead of importing an access table to the contacts, I'd like to import an
Access table that is an ODBC link. Is this possible?

 

[Sue Mosher [MVP-Outlook]]

If it's an Access table, it should be importable into contacts. What happens if you try it?

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Jeff]

In outlook's import wizard linked tables don't appear on the list of
available access tables, only imported tables.

I will not be updating the table using Access so importing it is not an
option.

 

[Sue Mosher [MVP-Outlook]]

What kind of data is the Access table linked to?

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Jeff]

It's an ODBC System DSN that is connected to a mySQL server datasource.

 

[Sue Mosher [MVP-Outlook]]

I tried some other linked tables and got the same result. I guess we can conclude that you'll have to write code or use a third-party tool to perform the import, rather than rely on Outlook's wizard. See http://www.outlookcode.com/d/customimport.htm

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Jeff]

Thanks for your help

I tried some other linked tables and got the same result. I guess we can conclude that you'll have to write code or use a third-party tool to perform the import, rather than rely on Outlook's wizard. See http://www.outlookcode.com/d/customimport.htm

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers