delphi 将dbf文件导入SqlServer2000数据库

[luohao14789]

将dbf文件导入SqlServer2000数据库
我用openrowset函数，相关代码如下
ADOQuery1.Close;
ADOQuery1.Clear;
str:='select * into datareport.itemtrs from openrowset(''MSDASQL'',''Driver={SQL Server };Initial Catalog=Datareport,SourceType=DBF,SourceDB=D:\itemtrs'',''select * from ['+filename+']'')';
ADOQuery1.ExecSQL;
有错误,请问将dbf导入sqlsever2000应该用什么数据源驱动？？？？？
网上查了些
select * into itemstrs from OpenDataSource('microsoft OLE DB Provider for SQL

Server','Data Source=''d:\itemtrs'';User ID='';Password='',Extended

Properties=dBase 5.0')...itemtrs
也有错误

请高手帮忙，指导，？
小弟感激万分

[ForFumm]

SELECT * into bmk
FROM OpenDataSource( ’Microsoft.Jet.OLEDB.4.0’,
  ’Data Source=”d:\itemtrs”;User ID=Admin;Password=;Extended properties=dBase 5.0’)

[luohao14789]

[Quote=引用 1 楼 forfumm 的回复:]

SQL code
SELECT * into bmk
FROM OpenDataSource( ’Microsoft.Jet.OLEDB.4.0’,
’Data Source=”d:\itemtrs”;User ID=Admin;Password=;Extended properties=dBase 5.0’)
[/Quote]

不行啊 报错 说data附近有错误，麻烦详细说明啊

[delphiluo123]

我告诉答案吧，准没错的
Q_1.SQL.Add('insert itemtrs SELECT * from OPENROWSET(''MICROSOFT.JET.OLEDB.4.0'',''dBase IV;HDR=NO;IMEX=2;DATABASE=D:\'',''select * from [itemtrs.dbf]'') ') ;
Q_1.ExecSQL;
我试了的。是成功的

[kye_jufei]

insert itemtrs SELECT * from OPENROWSET(''MICROSOFT.JET.OLEDB.4.0'',''dBase IV;HDR=NO;IMEX=2;DATABASE=D:\'',''select * from [itemtrs.dbf]'')