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)

方正中间件 www.founderfix.com