也是能通过Sql语句实现呀! 导入导出: ADOQuery1.SQL.Text:='insert into aa select * from bb' 添加字段: ADOQuery1.SQL.Text:='alert table aa add column cc varchar(10)'
query1.close; query1.sql.clear; query1.sql.add('insert into aa select * from bb'); query1.execute; query1.sql.clear; query1.sql.add('alert table aa add column cc varchar(10)); query1.execute;
beata88(学习,学习,再学习!)与 angle097113(亡命天使)说的都对就两是下面的二句; ADOQuery1.SQL.Text:='insert into aa select * from bb'ADOQuery1.SQL.Text:='alert table aa add column cc varchar(10)'
ADOConnection1.Execute('insert into aa select * from bb');
ADOConnection1.Execute('alert table aa add column cc varchar(10)');
导入导出:
ADOQuery1.SQL.Text:='insert into aa select * from bb'
添加字段:
ADOQuery1.SQL.Text:='alert table aa add column cc varchar(10)'
query1.sql.clear;
query1.sql.add('insert into aa select * from bb');
query1.execute;
query1.sql.clear;
query1.sql.add('alert table aa add column cc varchar(10));
query1.execute;
ADOQuery1.SQL.Text:='insert into aa select * from bb'ADOQuery1.SQL.Text:='alert table aa add column cc varchar(10)'