I have a Windows XP machine running Office 2000. When I am in Excel (new workbook) and select Data\Get External Data\New Database Query it takes around 2 minutes and then the msqry32.exe program shows up???? I want the Choose Data Source window to open so I can select an ODBC source connected to my SQL 2005 database. I have no problem accessing the ODBC source from MS Access. Any ideas what's wrong? I've even tried re-installing Office a couple of times.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Getting External Data from Excel 2000
- Thread starter tjbennett
- Start date
darryncooke
Technical User
are these the steps you are following?
screen shots would be good.
Darryn Cooke
| Marketing and Creative Services
- Thread starter
- #3
darryncooke
Technical User
Do you have the ODBC add-in installed? I don't believe this is a native feature of Excel even today, let alone 2000. I could be wrong.
Darryn Cooke
| Marketing and Creative Services
Darryn Cooke
| Marketing and Creative Services
- Status
