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.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.