Data could not be retrieved from data source on query ONLY

[CSP12345]

Hi all,

I am having a big issue where I am getting a Data could not be retrieved message when I am trying to import data into excel.

I can import tables from the same access database with no issues but as soon as I try to import the query I get the issue.

I have made sure there are no Errors i the data base and all fields have information in them.

Please I need your help.

 

[CSP12345]

Ok I have narrowed it down to 1 column, I have made another query of that query to see if it was something to do with an expression in it but it is not. If I hide that column and refresh the data connection on the xlsx spreadsheet I have no issues, unhide the column in access and have the issue why?

Will post in Access section as well.