快活林资源网 Design By www.csstdc.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.csstdc.com
广告合作:本站广告合作请联系QQ:858582 申请时备注:广告合作(否则不回)
免责声明:本站资源来自互联网收集,仅供用于学习和交流,请遵循相关法律法规,本站一切资源不代表本站立场,如有侵权、后门、不妥请联系本站删除!
免责声明:本站资源来自互联网收集,仅供用于学习和交流,请遵循相关法律法规,本站一切资源不代表本站立场,如有侵权、后门、不妥请联系本站删除!
快活林资源网 Design By www.csstdc.com
暂无评论...
更新日志
2024年04月19日
2024年04月19日
- 许惠钧《小海马说晚安 宝贝的睡眠浪潮 吉卜力哄睡钢琴》[FLAC/分轨][286.45MB]
- 薰妮1997-相逢梦中16首精选[香港永恒真存版][WAV+CUE]
- 郭宴《共同度过HQCD(纪念张国荣二十周年限量版)》2023[整轨WAV]
- RCAREDSEAL《SalutDAmour》[WAV+CUE]
- 陈升.1992-别让我哭【滚石】【WAV+CUE】
- 刘锡明.1993-Sincerely新曲精选歌集【华纳】【WAV+CUE】
- 轮回乐队.2002-我的太阳【文化艺术】【WAV+CUE】
- 小蓓蕾组合《粤语儿歌歌曲集》[WAV+分轨]
- 老虎鱼唱作诗人EugeneRuffolo在不同的灯火间SACD-ISO
- [ABC唱片]-《邓丽君-我怎能离开你》[6N纯银镀膜][WAV+CUE]
- 群星《千谎百计 原声音乐专辑》[320K/MP3][33.37MB]
- 群星《千谎百计 原声音乐专辑》[FLAC/分轨][95.84MB]
- 群星《城中之城 电视原声带》[320K/MP3][46.39MB]
- 于嘉珍.2001-山地情歌2辑【金桦】【WAV+CUE】
- 张洪量.1993-整个给你【滚石】【WAV+CUE】