In Excel 97 with MS Query, I want to make a query of a file I keep in a directory network called “Y:xxx”
I am working in “book1.xls”. I use the menu DataGet external dataRun a new Query. After selecting the file, when I click the “connect” button, I get the error message “Data Truncated” and cannot proceed.
After several negative attempts (which included re-installing .xls OBDC driver) I copied the excel database from Y: to C: (my PC). And it worked.
While this can be a solution, I dont want to duplicate files in different places of the network. Does anyone know how to overcome this problem?
Thank you
Guillermo
