excel 连接字符串的含义。
来源:互联网 发布:怎么买到淘宝客户信息 编辑:程序博客网 时间:2024/06/02 23:41
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:/MyExcel.xls;Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1"""
"HDR=Yes;" indicates that the first row contains columnnames, not data
"IMEX=1;" tells the driver to always read "intermixed" data columns as text. Note that this option might affect excel sheet write access negative.
TIP! SQL syntax: "Select * FROM [sheet1$]" - i.e. worksheet name followed by a "$" and wrapped in "[" "]" brackets.
TIP! Check out the [HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Jet/4.0/Engines/Excel] located registry REG_DWORD "TypeGuessRows". That's the key to not letting Excel use only the first 8 rows to guess the columns data type. Set this value to 0 to scan all rows. This might hurt performance.
Important note! The two double quota ("") in the string are escaped quotas (VB syntax), you may have to change this to your language specific escape syntax (ex. /") or maybe single quota (').
"HDR=Yes;" indicates that the first row contains columnnames, not data
"IMEX=1;" tells the driver to always read "intermixed" data columns as text. Note that this option might affect excel sheet write access negative.
TIP! SQL syntax: "Select * FROM [sheet1$]" - i.e. worksheet name followed by a "$" and wrapped in "[" "]" brackets.
TIP! Check out the [HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Jet/4.0/Engines/Excel] located registry REG_DWORD "TypeGuessRows". That's the key to not letting Excel use only the first 8 rows to guess the columns data type. Set this value to 0 to scan all rows. This might hurt performance.
Important note! The two double quota ("") in the string are escaped quotas (VB syntax), you may have to change this to your language specific escape syntax (ex. /") or maybe single quota (').
- excel 连接字符串的含义。
- C#连接Excel的连接字符串
- C#连接Excel文件的连接字符串
- 在Excel中连接字符串的方法
- 关于Access和Excel的连接字符串
- 不同Excel版本的连接字符串
- excel连接字符串
- Excel数据连接字符串
- excel 字符串连接
- Excel 连接字符串
- excel连接字符串
- Excel 连接字符串
- BuildExcelConnectionString excel 连接字符串
- Excel字符串连接
- [数据库连接字符串] EXCEL 连接字符串
- excel 字符串连接和求差集
- Asp.net连接Excel字符串
- [OLEDB]OLEDB对于不同版本Excel的连接字符串
- FileUpload控件上传图片并自动生成缩略图、带文字和图片的水印图
- C8050F02x单片机FLASH读写(Keil C编程心得)
- BI--SAP BI的权限管理
- 打开文件的方法&SHELLEXECUTEINFO 结构
- Bug的质量衡量
- excel 连接字符串的含义。
- 一个面像对像的计算器
- 《全方位体验Workshop10.1》第一部份
- asp.net2 统一搜索引擎关键字编码
- 《全方位体验Workshop10.1》的第二部分
- Microsoft Silverlight Tools Beta 2 for Visual Studio 2008 下载地址
- 在Eclipse上使用XFire开发WebService
- 方法签名
- 想作程序员怎么办??