How can I pull data from Access without hard coding the table name?

Hello everyone,

I am trying to import data from an Access database in the following manner:

conn = database.ODBCConection(databasename,username,password);
tablename = input('Enter tablename: ','s'):

curs = exec(conn,'SELECT * from %s',tablename);
curs = fetch(curs);

Where databasename, username and password are all user inputs like tablename. The exec command works if I simply put:

curs = exec(conn,'SELECT * from SalesLastMonth');

but I want to be able to make it more adaptable in terms of which table the script pulls from.

Any ideas on what the syntax is to make this possible? I greatly appreciate any assistance!

Thank you,

L

Answer 1

[Guillaume]

Nearly got it right:

exec(conn, sprintf('SELECT * from %s', tablename))

[L]

Thanks Guillaume! Learned from the best haha.