UNION ALL sql statement

[natejlefebvre]

I am having trouble combining two different worksheets in one. See the below information:

SELECT ['Chef Coats$'].* FROM ['Chef Coats$']
UNION ALL
SELECT *

FROM 'C:\Users\nlefebvre\Documents\polos.xlsx'.[polos$]

I keep getting the error message below, but I don't know what is wrong with the string.

"The SQL statement is not valid. There are no columns detected in the statement."

 

[bluesky63]

Hi mbizavin,

Thanks for the tips

I was trying to export one of my SharePoint List to excel iqy. According to the steps, we need to save as xlsx. Open up an excel workbook, follow steps till form3 after select the workbook that I had saved previously and return to Form2, I can't see any table in the drop-down to select

Any idea I miss out any steps ?