转换DBF文件,通常有以下3种转换方式:
1、dBase文件已经存在:
insert into
openrowset('MICROSOFT.JET.OLEDB.4.0',
'dBase III;DATABASE=d:','select from [.dbf]')
select * from AAA.dbo.BBB
2、SQL表文件已经存在:
insert into AAA.dbo.BBB select * from
openrowset('MICROSOFT.JET.OLEDB.4.0'
,'dBase III;DATABASE=d:','select from [.dbf]')
3、SQL表文件不存在,生成新表:
select * into
openrowset('MICROSOFT.JET.OLEDB.4.0'
,'dBase III;DATABASE=d:','select from [.dbf]')