Selecting Table names from array

[greg1127]

How do I select a table name, from an array, so that i can perform more operations on that table, then move on to the next?

I am using ASP, and the SQL code : tblRS.Open "SELECT Country FROM '"& tableNames(i,0) & "'", objConn

will not work.
Does any one know how to select the name of a table from an array to use it later on?

Thanks

 

[swampBoogie]

Remove the apostrophes surrounding the tablename.

 

[CajunCenturion]

I would try the statement without using the single quotes. The single quotes would be needed in Where clause values, but not around the table name. However, you might want to use square brackets, but it's not required, just in case a table name happens to be a reserved word.

tblRS.Open "SELECT Country FROM [" & tableNames(i,0) & "]", objConn

Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein