SQL to Excel [Paramater Query Syntax Issue]

[dekk]

When running the full macro (not shown), it delivers an error that '=' incorrect syntax.

The code is trying to extract data from SQL server into Excel

      objMyCmd.CommandText = "SELECT BU, JobDesc FROM Budget27MI_map" _
         & "WHERE BU =" & Worksheets("Sheet1").Range("A1").Value

Suggestions on syntax for parameter query to work?

[ck9663]

Try to put some spaces between your table name and the WHERE clause.

Happy Coding!!!

~~ CK