TheWennerWoman
Active Member
- Joined
- Aug 1, 2019
- Messages
- 303
- Office Version
- 365
- Platform
- Windows
This is really weird. I have a SQL query that is being run from Data<->Queries and it pulls data through just fine.
I have populated two spare fields in the source table and added them to the query in Excel......but it refuses to pull the data into the table!
If I run
in SQL Server Management Studio the data appears just fine but if I try that exact same query in Excel, nothing is returned?!
Has anyone come across this before?
I have populated two spare fields in the source table and added them to the query in Excel......but it refuses to pull the data into the table!
If I run
Code:
SELECT Spare_1, Spare_2 FROM MyTable
in SQL Server Management Studio the data appears just fine but if I try that exact same query in Excel, nothing is returned?!
Has anyone come across this before?