According to this thread

http://www.google.com/groups?threadm...ing.google.com

you can't have spaces in the path to your MDB.

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

"simsjr" wrote in message
...

So I'm trying to "Get External Data" from within Excel 97. We have a
password protected Access MDB on a company shared drive that we need to
access. Now, I can open the MDB directly from my workstation and I can run
queries stored within the database, but I get an error message when I try
to
access it through Excel 97 via the Create New Query option.

I have tried accessing the database both through ODBC or directly (with a
reference to the MDB location on the network). I specify a password during
both occasions, and here's the error message I get with each method:

"String data, right truncated on column number 1 (TABLE_CAT)"

What's up with this???