sorry for my poor english.
i just want to get data from excel file(.xls) ,and use it to create a table like this: CREATE TABLE TEST( a INTEGER, b INTEGER); BUT a & b should come from excel. just like :
query.prepare("INSERT INTO users(userName, passWord)"
"VALUES(?, ?)");
query.addBindValue(user);
query.addBindValue(pwd);
query.exec();
query = QSqlQuery(db);
query.prepare("INSERT INTO users(userName, passWord)"
"VALUES(?, ?)");
query.addBindValue(user);
query.addBindValue(pwd);
query.exec();
To copy to clipboard, switch view to plain text mode
up there ,it is INSERT TO, BUT i want "CREATE", that is it!
how to do this ?
thanks in advance !thank you all!
Bookmarks