Hello
Code adopted from below URL
https://analystcave.com/excel-using-sql-in-vba-on-excel-data/
Getting syntax error as per the above heading
when following query executed
SELECT [Sheet1$].[First Last], [Age], [Salary] FROM [Sheet1$] INNER JOIN [Sheet2$] ON [Sheet1$].[First Last]=[Sheet2$].[First Last]
getting error "No Value Given for One or More Required Parameters"
Can someone help me to correct the syntax for above SQL query ?
As this the first time implementing with SQL query
Thanks
SamD
Code adopted from below URL
https://analystcave.com/excel-using-sql-in-vba-on-excel-data/
Getting syntax error as per the above heading
when following query executed
SELECT [Sheet1$].[First Last], [Age], [Salary] FROM [Sheet1$] INNER JOIN [Sheet2$] ON [Sheet1$].[First Last]=[Sheet2$].[First Last]
getting error "No Value Given for One or More Required Parameters"
Can someone help me to correct the syntax for above SQL query ?
As this the first time implementing with SQL query
Thanks
SamD
Last edited: