E
Eddy
I have an excel spreadsheet importing data from MSQuery
link to MSSQL2000 database via ODBC. We have updated data
on the SQL databse but query on the spreadsheet dose not
pickup changes made to the data after refresh option is
selected. However it dose pickup updated data if the
query is recreated from scratch. I need the saved query
to auto-refresh this spreadsheet when it is openned. It is
not very useful if one has to recreate the query everytime
it is openned. Hope some of you may have some answer to
this. Thanks.
link to MSSQL2000 database via ODBC. We have updated data
on the SQL databse but query on the spreadsheet dose not
pickup changes made to the data after refresh option is
selected. However it dose pickup updated data if the
query is recreated from scratch. I need the saved query
to auto-refresh this spreadsheet when it is openned. It is
not very useful if one has to recreate the query everytime
it is openned. Hope some of you may have some answer to
this. Thanks.