Changing Data Source Driver
 

I use Microsoft query in Excel to dowload data using Client Access ODBC (32 - Bit) driver. However, my IT department has recently changed from using Client Access to using Rumba. Although I want my queries to access the same information, I have had to set up new ODBC data source using Rumba AS/400 Optimized Server (32 - Bit) driver. I have named the data source exactly as it was when the Client Access data source was in place, but when I go to edit my query, in Excel, I get the following message:

Microsoft Excel:
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

I presume that this message is appearing because I have changed the driver. Is it?
If so, is there anyway of resolving this, short of actually deleting all my queries and starting again?
PLEASE HELP!!

Changing Data Source Driver
 

S

See my response in querydao

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"S Taylor" wrote in message
...
I use Microsoft query in Excel to dowload data using Client Access ODBC
(32 - Bit) driver. However, my IT department has recently changed from using
Client Access to using Rumba. Although I want my queries to access the same
information, I have had to set up new ODBC data source using Rumba AS/400
Optimized Server (32 - Bit) driver. I have named the data source exactly as
it was when the Client Access data source was in place, but when I go to
edit my query, in Excel, I get the following message:

Microsoft Excel:
[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified

I presume that this message is appearing because I have changed the
driver. Is it?
If so, is there anyway of resolving this, short of actually deleting all
my queries and starting again?
PLEASE HELP!!