troubleshooting Question

select rows in access from excel vba

Avatar of Aiysha
AiyshaFlag for United States of America asked on
VBASQL
1 Comment1 Solution21 ViewsLast Modified:
worksheet 1

A                B
1123
2452
3452
4456


I want to write a query to return all records from a table in sql where value in a column equals first 2 digits of cells in column1 of active speradsheet.

SELECT * FROM testtable where column1 in  left(cells(a,1),2)....

Please note I am writing this macro in excel VBA

Thank you.
ASKER CERTIFIED SOLUTION
NorieAnalyst Assistant
Join our community to see this answer!
Unlock 1 Answer and 1 Comment.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros