如何动态传递文件名， [英] How to pass file name dynamically ,

问题描述

大家好

如何使用SQL Server 2000从xls文件读取数据并将其放入sql表中时动态地将文件名传递给OpenRowSet

hallo to all

How to pass file name dynamically to OpenRowSet, while reading data from xls file and putting into sql table using sql server 2000

推荐答案

在过程中尝试类似的操作

Try something like this in procedure

DECLARE @docpath nvarchar(200)
SET  @docpath = ''E:\Workflow\SPP\Attachments\TR\ExcelUpload\claim.xls''
DECLARE @sql nvarchar(1000)
SET @sql = ''INSERT INTO [YourTable] ([Column1], [Column2]) SELECT A.[Column1], A.[Column2] FROM OPENROWSET (''''Microsoft.ACE.OLEDB.12.0'''', ''''Excel 12.0;;Database='' + @docpath + '''''', ''''select * from [Sheet1

'''') AS A'' exec(@sql)

'''') AS A'' exec(@sql)

这篇关于如何动态传递文件名，的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！