Hi Guys. when i tried to compare two excel using sql query. Im getting an missing operator error in the below query: RemoteException wrapping System.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC Excel Driver] Syntax error (missing operator) in query expression ‘‘Matching’ [from] [Sheet1$] T1’
Query: “UPDATE [Sheet2$] SET [Status]=‘Matching’ from [Sheet1$] T1, [Sheet2$] T2 where T1.[Name] = T2.[Name];”