H
Henrik
Hi,
We have some excel files which connects to a ODBC data source (Oracle db)
Some of those excel spreadsheets we are not able to edit the data source any
longer(which should have brought us into Ms query)
What happens when we try is that Ms query opens very shortly and then closes
again before we can see the query that have been build)
My question is now - is there some way that we can identify what data source
(the name of the dqy file) that is used in excel - for example by
decoding/analysing the xls file...?
We are using Excel 2003 and Windows XP
Thanks
Henrik
We have some excel files which connects to a ODBC data source (Oracle db)
Some of those excel spreadsheets we are not able to edit the data source any
longer(which should have brought us into Ms query)
What happens when we try is that Ms query opens very shortly and then closes
again before we can see the query that have been build)
My question is now - is there some way that we can identify what data source
(the name of the dqy file) that is used in excel - for example by
decoding/analysing the xls file...?
We are using Excel 2003 and Windows XP
Thanks
Henrik