sql语句读取dbf文件_sql语句_数据库开发

declare @sqlexpr varchar(5000)
declare @FileName varchar(500)
declare @SheetName varchar(200)
set @sqlexpr =''

set @FileName='D:\SDFile'
set @SheetName='book'
set @sqlexpr='SELECT * into dda
FROM OpenDataSource( ''Microsoft.Jet.OLEDB.4.0'',
''Data Source="'+@FileName+'";User ID=Admin;Password=;Extended properties=dBase 5.0;'')...'+@SheetName
exec(@sqlexpr)