I am trying to access am MS Access data base fromwithin Excel to create a pivot table. I keep getting e following error within MS Query

String data, right truncated on column number 1 [Table_Cat]

I am running Windows Xp and office 97. The proplems has started since I reinstalled my opperating system and everything else on a new disk. Never happened before???

Any help?