VBA Excel SQL Error "No Value Given for One or More Required Parameters"

[SamDsouza]

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

 

[Fazza]

Hi, Sam

IIRC, that error is when a field name in the query is not found in the data.

Suggest you carefully check field headers "First Last", "Age", and, "Salary" match between the worksheets & the SQL.
For example, a trailing space like "Age " on the worksheet would be the sort of thing that gives mis-match, and then the error.

Also, if your "Sheet2" has similar field names, best to explicitly reference the source table you want to select. That is,
SELECT [Sheet1$].[First Last], [Sheet1$].[Age], [Sheet1$].[Salary]

regards, Fazza

 

[SamDsouza]

Thanks Fazza really appreciate your guidance. . BTW can you suggest website or URL where i can refer to maximum SQL syntaxes.

 

[Fazza]

Maximum. That is done like this,

SELECT MAX(some field), other fields you want
FROM table
GROUP BY other fields you want

Order of fields in SQL doesn't matter, btw.

If you want to filter,

SELECT MAX(some field), other fields
FROM table
WHERE something = 'this one'
GROUP BY other fields

And if you want to select based on the maxima,

SELECT MAX(some field), other fields
FROM table
WHERE something = 'this one'
GROUP BY other fields
HAVING MAX(some field) > 1000

PS. I have no specific site recommendations for SQL syntax