SELECT *
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="F:\Borland\Shared\Data\";Extended properties=dbase 5.0')...animals
--animals.dbf
2
if exists(select 1 form 源表 where 主键 not in (select 主键 form 目的表))
insert into 目的表 (col1,col2....) select col1,col2.... from 源表 where 主键 not in (select 主键 form 目的表)