declare @filename varchar(40),@s varchar(4000)
select @FileName = 'aa.DBF'
set @s='insert into openrowset(''MSDASQL'',''Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB=d:\'',
''SELECT * FROM '+@FileName+''' ) select * from tt '
exec(@s)
select @FileName = 'aa.DBF'
set @s='insert into openrowset(''MSDASQL'',''Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB=d:\'',
''SELECT * FROM '+@FileName+''' ) select * from tt '
exec(@s)
select @FileName = CONVERT(VARCHAR(10),@DateS,120)+'.DBF'
set @s='insert into openrowset(''MSDASQL'',''Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB=d:\'',''SELECT * FROM '+@FileName+''') select * from tt '
print @s
exec(@s)
insert into
openrowset(''MSDASQL'',
''Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB=d:\'',SELECT * FROM '+@FileName+''' )'exec (@sql)