兴国资源网 Design By www.nnzcdc.com
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)
兴国资源网 Design By www.nnzcdc.com
广告合作:本站广告合作请联系QQ:858582 申请时备注:广告合作(否则不回)
免责声明:本站资源来自互联网收集,仅供用于学习和交流,请遵循相关法律法规,本站一切资源不代表本站立场,如有侵权、后门、不妥请联系本站删除!
免责声明:本站资源来自互联网收集,仅供用于学习和交流,请遵循相关法律法规,本站一切资源不代表本站立场,如有侵权、后门、不妥请联系本站删除!
兴国资源网 Design By www.nnzcdc.com
暂无评论...
更新日志
2024年04月24日
2024年04月24日
- 绝唱48首连续热唱《48Non-StopGreatestOldiesVol.1》wav
- 【FIM】【原版】《FiveSongbirds》(SACD)ISO
- 中东肚皮舞音乐Drumspyder《销魂鼓点Kytheria》WAV分轨
- 曝基利安·墨菲将出演《孤岛惊魂7》!新任大反派
- 《宝可梦传说Z-A》新情报:XY/ORAS的MEGA进化都将回归
- 《星刃》发售倒计时五天!欢迎来到破败都市Xion
- 隔壁老樊.2024-晚霞后呢(EP)【看见音乐】【FLAC分轨】
- 郑丽丝.1986-若是有缘(LP版)【综一】【FLAC分轨】
- 群星.1997-宝丽金88极品音色系列·合唱碟王1+2【宝丽金】【WAV+CUE】
- dnf最值得幻化的四把武器
- dnf机械七战神实验室怎么进
- dnf机械七战神首领
- 凤凰传奇《舞动奇迹》wav
- 群星-最热最好听的DJ舞曲《你牛什么牛[中文舞曲]》[WAV+CUE]
- 重低音串烧版DJ舞曲HiFi发烧碟wav