Cannot Query MDB!
 

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???

Cannot Query MDB!
 

Thanks for the response - and good to know. However, I just checked and there
are no spaces in the path to the MDB file.

Any other suggestions? :)

"Dick Kusleika" wrote:

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???

Cannot Query MDB!
 

"simsjr" wrote in message
...
Thanks for the response - and good to know. However, I just checked and
there
are no spaces in the path to the MDB file.

Any other suggestions? :)


Not really. You can read the posts here

http://www.google.com/groups?as_q=St...=lang_en&hl=en

I've read through them in the past, but there didn't seem to be one simple
answer. Maybe you will find a post that fits your situation, though.

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