DDR爱好者之家 Design By 杰米
select *
from openrowset('Microsoft.Jet.OLEDB.4.0'
,'Excel 8.0;HDR=YES;IMEX=1;DATABASE=d:\folder\excel.xls',Sheet1$)
-------NOTE------
Setting IMEX=1 tells the driver to use Import mode. In this state, the registry setting ImportMixedTypes=Text will be noticed. This forces mixed data to be converted to text. For this to work reliably, you may also have to modify the registry setting, TypeGuessRows=8. The ISAM driver by default looks at the first eight rows and from that sampling determines the datatype. If this eight row sampling is all numeric, then setting IMEX=1 will not convert the default datatype to Text; it will remain numeric.
You must be careful that IMEX=1 not be used indiscriminately. This is IMPORT mode, so the results may be unpredictable if you try to do appends or updates of data in this mode.
The possible settings of IMEX are:
0 is Export mode
1 is Import mode
2 is Linked mode (full update capabilities)
from openrowset('Microsoft.Jet.OLEDB.4.0'
,'Excel 8.0;HDR=YES;IMEX=1;DATABASE=d:\folder\excel.xls',Sheet1$)
-------NOTE------
Setting IMEX=1 tells the driver to use Import mode. In this state, the registry setting ImportMixedTypes=Text will be noticed. This forces mixed data to be converted to text. For this to work reliably, you may also have to modify the registry setting, TypeGuessRows=8. The ISAM driver by default looks at the first eight rows and from that sampling determines the datatype. If this eight row sampling is all numeric, then setting IMEX=1 will not convert the default datatype to Text; it will remain numeric.
You must be careful that IMEX=1 not be used indiscriminately. This is IMPORT mode, so the results may be unpredictable if you try to do appends or updates of data in this mode.
The possible settings of IMEX are:
0 is Export mode
1 is Import mode
2 is Linked mode (full update capabilities)
DDR爱好者之家 Design By 杰米
广告合作:本站广告合作请联系QQ:858582 申请时备注:广告合作(否则不回)
免责声明:本站资源来自互联网收集,仅供用于学习和交流,请遵循相关法律法规,本站一切资源不代表本站立场,如有侵权、后门、不妥请联系本站删除!
免责声明:本站资源来自互联网收集,仅供用于学习和交流,请遵循相关法律法规,本站一切资源不代表本站立场,如有侵权、后门、不妥请联系本站删除!
DDR爱好者之家 Design By 杰米
暂无评论...
更新日志
2024年04月24日
2024年04月24日
- F4《流星雨》[FLAC整轨][499M]
- 物华弥新鹿角立鹤厉害吗 鹿角立鹤培养建议分享
- 物华弥新芙蓉炉厉害吗 芙蓉炉培养建议分享
- 星之翼手游新手开荒指南大全 星之翼新手怎么快速上手
- 赵传2014-歌声传情3CD[广东音像][WAV+CUE]
- 江蕙2002-台语典藏系列·黄金版8CD[WAVCUE]
- 薰妮1980-雾里玫瑰[香港永恒真存珍藏版][WAV+CUE]
- 《给他爱5》被移植到NS平台:玩会序章就崩溃了
- 《星刃》MV幕后公开 韩国女星BIBI大赞服装设计
- 日本人妻COS《葬送的芙莉莲》尤贝尔:死鱼眼超还原
- 陈升.2019-七天【新乐园】【WAV+CUE】
- 痛仰乐队.2014-愿爱无忧【禾广娱乐】【WAV+CUE】
- 梁汉文.2001-MUSIC.IS.THE.ANSWER【华星】【WAV+CUE】
- 物华弥新果树双管瓶厉害吗 果树双管瓶培养建议分享
- 物华弥新玉琮王厉害吗 玉琮王培养建议分享