sql查询混乱 [英] sql query confusion ...

问题描述

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$]')

what is the ''imex'' means in the query???

推荐答案

')

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

what is the ''imex'' means in the query???

"IMEX = 1;"告诉驱动程序始终以文本形式读取混合"(数字，日期，字符串等)数据列.请注意，此选项可能会对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."

I picked this up from here[^].

这是您问题的转发.如果您对原始帖子的答案有一些澄清，为什么不对其发表评论，而不是投票否决并发布相同的问题.

sql查询问题....... [

This is a repost of your question a while ago. If you have some clarifications on the answer of your original post, why not comment on it, instead of downvoting the answer and posting the same question.

sql query problem.......[^]

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