I have data which is held in multiple Excel Spreadsheets and imported SharePoint Lists (Sets for each Department Programme), that I want to collect and report on.
I have been able to create SQL scripts using the Query Builder on separate Lists and Spreadsheets to create specific reports.
However when I try to create a Heterogeneous connection query using the Cross-Connection Query Mode I get an error, which relates to the columns names having spaces in them (e.g. ‘Approved Budget’). The Query Builder has no issues with this, but not so when using the Cross-Connection Query Mode.
Is this a bug?
I am not able to change the table column names and remove the spaces from the SharePoint Lists and Excel Spreadsheets.
Is there another way I can make the Cross-Connection Query Mode work?
Any help welcome.
Thank you in advance.