Solved: Import data into a selectable table

[Van Ieperen]

Is it possible to copy data to a table with a selectable name?

I am trying this,

Tablename = Combobox.Value
INSERT INTO (Tablename) SELECT etc etc

But that sure doesn't work.

Help would be appreciated.

[asingh]

Hi,

I just closed out a thread..which addressed a similiar problem...firing a query using a dynamic table name..have a look it. If you still face problems..let us know..would be happy to help you out.

The thrread link is:
http://vbaexpress.com/forum/showthread.php?t=13549

best of luck....rgds

asingh

[Van Ieperen]

Thanks a lot, will do.