sql查询问题....... [英] sql query problem.......

问题描述

insert  INTO tblcharges select * FROM OPENROWSET(''Microsoft.Jet.OLEDB.4.0'', ''Excel 3.0;imex=1;hdr=yes;Database=C:\ss1.xls'', ''select * from [sheet1$]'')

推荐答案

'')

"imex"在查询中是什么意思?

what does the ''imex'' mean in the query?

"IMEX = 1;"告诉驱动程序始终以文本形式读取混合"(数字，日期，字符串等)数据列.请注意，此选项可能会影响excel工作表写入访问权限.
Excel的连接字符串 [ ^ ]

"IMEX=1;" tells the driver to always read "intermixed" (numbers, dates, strings etc) data columns as text. Note that this option might affect excel sheet write access negative.
Connection strings for Excel[^]

这篇关于sql查询问题.......的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！