I keep getting an *** Error: (HY000) [Microsoft][ODBC Excel Driver] Operation must use an updateable query. when I try to insert a new record into a table. And I can't make heads or tails as to why i am getting this error from this SQL statment.
Hmm. Try moving the file to a local destination and try again. I assume that Q:\ is a shared drive?
If a local xls works, then maybe you will need to specify a user and password for whatever machine Q is actually on, or make sure that machine has a user with the same name and pass as you are using on the silktest machine.
Chris R Mead
The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.