如何将Access数据库里的a表里的部分数据移到b表里
这个是复制的,有没有直接移动不用在删除ZT_directory表里的数据
conn1.Open()
comm1.CommandText = insert into ZT_directory_History select * from ZT_directory where ID= & LabelID.Text
comm1.ExecuteNonQuery()
conn1.Close() 关闭连接
__________________________________________________________________________
还有2个表分别在2个数据库中,应该如何写
__________________________________________________________________________
comm1.CommandText = insert into ZT_directory_History select * from ZT_directory where ID= & LabelID.Text
直接再加一条语句
comm1.CommandText = insert into ZT_directory_History select * from ZT_directory where ID= & LabelID.Text & DELETE FROM ZT_directory where ID= & LabelID.Text
__________________________________________________________________________
两个数据库的话,可以在表名前面加数据库名,如: A库.table1
__________________________________________________________________________
comm1.CommandText = insert into ZT_directory_History select * from ZT_directory where ID= & LabelID.Text & DELETE FROM ZT_directory where ID= & LabelID.Text
没有反应呀
__________________________________________________________________________
dim asdf as string
你把第一个库里的数据提出来赋值给asdf,
再用asdf插入到第二个库里,
建立两个数据库连接
__________________________________________________________________________
这个是复制的,有没有直接移动不用在删除ZT_directory表里的数据
conn1.Open()
comm1.CommandText = insert into ZT_directory_History select * from ZT_directory where ID= & LabelID.Text
comm1.ExecuteNonQuery()
conn1.Close() 关闭连接
__________________________________________________________________________
还有2个表分别在2个数据库中,应该如何写
__________________________________________________________________________
comm1.CommandText = insert into ZT_directory_History select * from ZT_directory where ID= & LabelID.Text
直接再加一条语句
comm1.CommandText = insert into ZT_directory_History select * from ZT_directory where ID= & LabelID.Text & DELETE FROM ZT_directory where ID= & LabelID.Text
__________________________________________________________________________
两个数据库的话,可以在表名前面加数据库名,如: A库.table1
__________________________________________________________________________
comm1.CommandText = insert into ZT_directory_History select * from ZT_directory where ID= & LabelID.Text & DELETE FROM ZT_directory where ID= & LabelID.Text
没有反应呀
__________________________________________________________________________
dim asdf as string
你把第一个库里的数据提出来赋值给asdf,
再用asdf插入到第二个库里,
建立两个数据库连接
__________________________________________________________________________