用SQL语句的话: insert into student2(field1,field2...) select flied1,field2... from student1 其中field1,field2 写成相同字段就OK了!
DBF文件吗? insert into student2(field1,field2...) select flied1,field2... from OPENROWSET('MICROSOFT.JET.OLEDB.4.0' ,'dBase IV;HDR=NO;IMEX=2;DATABASE=C:\','select * from [student1.dbf]')
其中一个表是全校的学生信息表student1,现在想把这个表中的有用的字段导入到另一个表student2中,student1表的字段和student2的字段名称不一样而且要有选择得导入到student1中,也就是说要把两个表中的字段对应起来,比方说student1中的name1字段在student2中对应的字段是name2,请问这样该如何做呢??最好能具体点,小弟是个新手!
insert into student2(field1,field2...) select flied1,field2... from student1
其中field1,field2 写成相同字段就OK了!
insert into student2(field1,field2...) select flied1,field2... from
OPENROWSET('MICROSOFT.JET.OLEDB.4.0'
,'dBase IV;HDR=NO;IMEX=2;DATABASE=C:\','select * from [student1.dbf]')