Hi,

Can anybody spot the syntax of the following codes?

SELECT ['MasterList$'].[Userid] FROM `D:\Temp\Test.xlsx`.['MasterList$']


It works in my another excel data connection

SELECT ['eSilk Y2000-2010$'].[STATUS] FROM `D:\Temp\Pen-scanning\Corp.xlsx`.['eSilk Y2000-2010$'] WHERE ([Result return] = 'BINGO')


Don't know what is wrong with the sql statement