Results 1 to 1 of 1
2001-05-08, 17:58 #1
- Join Date
- Apr 2002
- Houston, Tx, USA
- Thanked 0 Times in 0 Posts
MS Query - data truncated error message
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?