How can I pull data from Access without hard coding the table name?
3 views (last 30 days)
Show older comments
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
0 Comments
Accepted Answer
More Answers (0)
See Also
Categories
Find more on Database Toolbox in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!