I'm attempting a query using VBA in Excel. Stepping through, I get the error as in the thread subject at '.Open SQL'
I've checked and double checked I have correct spelling and case, etc but I cannot see where the problem is!
I'd be very grateful if anyone could help me identify the problem with the code below.
-Using Excel & Access 2002
Code:
Dim xName As String
Dim xStart As Date