Varible for Table Name

[DaveOLW]

In VB project ADODB Database How do I use a variable for the Table Name?

In the code below the "SUC_85" is the table name, I want to use a variable in this position to save writing a lot more code.

rcsInfpen "Select * from SUC_85 Order By ID", conInfo, adOpenDynamic, adLockOptimistic

 

[lespaul]

something like this should work:



rcsInfpen "Select * from " & tableNameVariable & " Order By ID", conInfo, adOpenDynamic, adLockOptimistic

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases: The Fundamentals of Relational Database Design

 

[DaveOLW]

Leslie

Yes that works Thanks, had searched and could not find I knew there must be a simple solution. Thanks