External data err

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DL - 04 Jun 2004 22:21 GMT

Excel 2k, win2k both updated
Wishing to link to an Access2k db.
Any attempt to 'get external data' causes excel to stop responding; no link
or external data window opens.
Have tried a repair, a reinstall, cleared the excel reg.key, cleared all tmp
files, uninstalled and reinstalled, all with no change.
Suggestions as to what next?
This works fine on my other sys, win2k and winxp

Reply to this Message

BrianB - 07 Jun 2004 11:06 GMT

You may need to custom install ODBC (Open Database connectivity) fro
the office setup disk. You should be able to run the disk to add thi
functionality without re-installing everything.

I don't think that this is installed by default. In XL97 which I a
using at present this puts an item into Control Panel. Can't remembe
what 2000 does

--
Message posted from http://www.ExcelForum.com

Reply to this Message

DL - 08 Jun 2004 15:08 GMT

MDAC 2.8 , includes ODBC, installed and tested with MS Component Checker,
all OK

> You may need to custom install ODBC (Open Database connectivity) from
> the office setup disk. You should be able to run the disk to add this
[quoted text clipped - 6 lines]
> ---
> Message posted from http://www.ExcelForum.com/

Reply to this Message

DL - 17 Jun 2004 14:46 GMT

The problem is cured; caused apparently by my Silicon Image raid utility
application, written in Java, causing a conflict. - Closed the utility and
now all ok

> MDAC 2.8 , includes ODBC, installed and tested with MS Component Checker,
> all OK
[quoted text clipped - 9 lines]
> > ---
> > Message posted from http://www.ExcelForum.com/

Reply to this Message