Using Excel 2007 VBA
Tables in Excel Sheet
using ADODB Connection and Recordset
select * from [tblBFLC$] where [Body ID] IN (select DISTINCT [Body ID] from [tblBody$] where [Luminaire Type] = 'Interior') and [LED Type] = 'COB'
This does not work:
select * from [tblBFLC$] where [Family ID] IN (select DISTINCT [Family ID] from [tblFamily$] where [Family] = 'ACLAP') and [LED Type] = 'COB'
I have checked for correct Field names.
No value given for one or more required parameters