Displaying list of tables using VB code in Access

Alastor · Aug 27, 1998

I am trying to automate the importing of data into a database. I have created a form that uses VB code import the data and modify it to it's proper format. I then use a SQL statement to append the data to a table. Unfortunately I can't get around hard coding the table name into the SQL statement. I would like to display a list of tables for the user to choose from, and then put the table name into the SQL statement. Is this possible? Any help would be appreciated.

DarkMan · Aug 27, 1998

You may have to use a SELECT CASE statement and use separate SQL statements in each case...

Alastor · Sep 1, 1998

I was hoping for something a bit more dynamic. The Select Case statement did work however. Thanks.

B · Oct 19, 1998

You could use a For Each loop to loop through the TableDefs collection. Each TableDef is a table in your database. You can use the variable from the For Each loop in your SQL expression. If you get stuck, just shout...

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Displaying list of tables using VB code in Access

Alastor

MIS

DarkMan

Programmer

Alastor

MIS

B

MIS

Similar threads

Part and Inventory Search

Sponsor