Combining Source Data from two separate Excel Workbooks via SQL Query under Table Properties

[trebligbc]

Mr. Excel,</SPAN>

I’m trying to combine separate workbooks (Nov2008.xlsx and Dec2008.xlsx) with Identical column headers similar to what’s being demonstrated in this online video.</SPAN>
http://www.contextures.com/PowerPivot-Identical-Excel-Files.html</SPAN>

But it’s not working… getting the following error!</SPAN>
(In fact, I get that same error even when trying to combine the two files downloaded from the site of the video!!)</SPAN>

• “The SQL statement is not valid. There are no columns selected in the statement”</SPAN>

I pretty much followed the online video example to the letter. Any ideas?</SPAN>

</SPAN></SPAN>

Is there a way that you know of to do this?</SPAN>

Thanks,</SPAN>
Chris Gilbert</SPAN>

 

[trebligbc]

I discovered the problem!
In the SQL "UNION ALL" statement, the reference to the "to be merged" workbook/worksheet needs to be surrounded by `[grave accent] characters, not single- or double-quotes.

Thus,

SELECT [EastSales$].* FROM [EastSales$]UNION ALLSELECT * FROM `C:\_TEST\WestSales.xlsx`.[WestSales$]</PRE>
works when the grave accent character (on the tilde key - in the upper-left corner under the [ESC] key on my keyboard) is used. Details!