【DM版本】:03134284604-20260707-335949-20228
【操作系统】：Kylin V10
【CPU】:x86
【问题描述】*：SQL server opendatasource连接excel文件进行数据操作

SELECT @errorMessage = REPLACE((SELECT CAST(行号 AS VARCHAR(10)) + ',' + 二维码 + '—'
FROM OPENDATASOURCE('Microsoft.ACE.OLEDB.12.0',
'Data Source=D:\tes二维码导入共享\二维码.xlsx;Extended Properties=Excel 12.0')...[Sheet1$]
WHERE ISNULL(二维码,'') <> ''
AND (CHARINDEX('B',RIGHT(二维码,6)) > 0 OR CHARINDEX('I',RIGHT(二维码,6)) > 0
OR CHARINDEX('O',RIGHT(二维码,6)) > 0 OR CHARINDEX('Z',RIGHT(二维码,6)) > 0)
ORDER BY CAST(行号 AS INT)
FOR XML PATH('')),'—',CHAR(13) + CHAR(10))