How to change the name in the pb + SQL server backup a single table, is refers to the name of the table after the backup is the custom,

CodePudding user response:

Retrieve table, backup to TXT, using saveas function name their own Settings,
Restore deleted table record, reoccupy ImportFile function

CodePudding user response:

String Mysql
String tablebak
String tableres
Tablebak=aaa. Text
Tableres=BBB. Text
Mysql="select * into" + tablebak + "from" + tableres

The EXECUTE IMMEDIATE: Mysql;

CodePudding user response:

Pro! Give a good answer!

CodePudding user response:

Saveas () is useful! Easily the window data export to Excel table, thanks liubocy!