Change ODBC driver in EXCEL query

[hart270]

I have a query setup in excel that pulls data from our AS400. After upgrading the AS400 the ODBC driver is no longer valid. I setup a new one, but when I try to edit the query I get a message that it is not supported and I hit OK and I am back to my worksheet. How do I change this to the new ODBC driver?

 

[Mark W.]

Are you using XL2000? Did you setup the DSN using the Microsoft ODBC Administrator?
This message was edited by Mark W. on 2002-10-16 10:26

 

[hart270]

Yes it is xl2000 and the DSN is configured with the new odbc driver, but the query still is looking for the one that does not work

 

[Mark W.]

You could direcly edit the code using the Microsoft Script Editor (Shift+Alt+F11)... but, be careful. And, experiment with a copy of your worksheet first.