haopeng
25th December 2013, 10:12
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 = QSqlQuery(db);
query.prepare("INSERT INTO users(userName, passWord)"
"VALUES(?, ?)");
query.addBindValue(user);
query.addBindValue(pwd);
query.exec();
up there ,it is INSERT TO, BUT i want "CREATE", that is it!
how to do this ?
thanks in advance !thank you all!
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 = QSqlQuery(db);
query.prepare("INSERT INTO users(userName, passWord)"
"VALUES(?, ?)");
query.addBindValue(user);
query.addBindValue(pwd);
query.exec();
up there ,it is INSERT TO, BUT i want "CREATE", that is it!
how to do this ?
thanks in advance !thank you all!