Excel: Passing Cell Value to VBA SQL Statement

Question

I have searched forever and cannot find a solution that works. Most likely because of ignorance.

The database that I am querying is Interbase so the SQL syntax might be different than what I'm used to. When I add the following line to my SQL statement I get an error "Run time error: 1004" SQL Syntax Error.

"AND    p.DISPLAY_NAME LIKE %" & Worksheets("Page1").Range("H9").Value & "%"

Any help is greatly appreciated!

I think you are more likely to get help if you avoid expressions such as "I have searched forever". — Andy G
– Andy G, Commented Jun 28, 2013 at 18:49

Andy G · Accepted Answer · 2013-06-28 18:46:04Z

2

I don't know about interbase but I suspect you need to surround the text-expression with apostrophes:

"AND    p.DISPLAY_NAME LIKE '%" & Worksheets("Page1").Range("H9").Value & "%'"

Remove the unnecessary spaces as well:

"AND p.DISPLAY_NAME LIKE '%" & Worksheets("Page1").Range("H9").Value & "%'"

answered Jun 28, 2013 at 18:46

Andy G

19.4k5 gold badges49 silver badges70 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Excel: Passing Cell Value to VBA SQL Statement

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related