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

5 次查看（过去 30 天）
L
L 2017-2-11
评论： L 2017-2-13
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

请先登录，再回答此问题。

采纳的回答

Guillaume
Guillaume 2017-2-11
Nearly got it right:
exec(conn, sprintf('SELECT * from %s', tablename))

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Database Toolbox 的更多信息

标签

产品

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by