How can I pull data from Access without hard coding the table name?
조회 수: 1 (최근 30일)
이전 댓글 표시
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
채택된 답변
추가 답변 (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!