Hi
I am trying to view the results of a Access 97 query using 'Get external data' in MS Excel. I have been doing this for quite a while now and it works fine.
But I have made some changes to the database and when I try a connect to it now in Excel I get the following error message.
'String data, right truncated on column number 1 (TABLE_CAT)'
Can anyone help please.
Thanks
I am trying to view the results of a Access 97 query using 'Get external data' in MS Excel. I have been doing this for quite a while now and it works fine.
But I have made some changes to the database and when I try a connect to it now in Excel I get the following error message.
'String data, right truncated on column number 1 (TABLE_CAT)'
Can anyone help please.
Thanks