Problem with JOIN in Excel Query

Hi,
I have the following SQL statement when querying an Excel Workbook.

Please Login or Register  to view this content.

I am getting the error "No value given for one of or more required paramenters." when I run this code. The error is at the statement where the RecordSet rsData is opened.

I think the error is related to the join part of the SQL.

The problem is somewhere in "INNER JOIN [Antifungal$] ON [Cancidas$].[Cust ID] = [Antifungal$].[Cust ID]"

because when I take out the JOIN part, the code runs.

Either, it does not like the sheet name that I am joining with or maybe the column names [Cust ID], or, plain,
you just cannot do JOINS in Excel SQL.

I've checked the columns names and the worksheet name and they match with the actual names in the worksheet.

Can anyone help me figure out the issue.


Thanks-in-advance.



Saad