I’m trying to utilize parameters in my Access db query. I’m testing by using a very simple Select statement with the From clause coming from an input string parameter. So far I’ve tried the following:
"Select * From @RBQWeekTable"
This gives me an error stating there’s an incomplete query clause.
"Select * From ?"
When I run this the error simply states that there’s a syntax error in FROM clause.
Am I missing an escape character or something? Anyone know the syntax on how to pass in parameters to a .accdb file?