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
Bookmarks