Data could not be retrieved from data source on query ONLY

CSP12345

Board Regular
Joined
Oct 1, 2014
Messages
52
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.
 

Some videos you may like

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

CSP12345

Board Regular
Joined
Oct 1, 2014
Messages
52
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,465
Messages
5,528,962
Members
409,848
Latest member
Blomsten
Top