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)
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