Excel SQL add-in, load external Excel file. Syntax error

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...
1.33K views
0

Excel SQL example 1: Loading data from an external Excel file

SELECT * FROM C:Data.xlsx.Sheet1$

Hi, I have tried to get this example select statement (from the tutorial) to work but without success.
(path is correct, etc).

All I get is “syntax error in FROM clause”

Anyone know why?

(select queries from open workbook sheets work fine)
(Excel 2013)
Thanks,
/Steve

Simply the best place to learn Excel VBA