OLEDB连接字符串中的IMEX是什么? [英] What is IMEX within OLEDB connection strings?

问题描述

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=localhost;Extended Properties=""Excel 8.0;HDR=Yes;IMEX=2"

上述连接字符串中IMEX=2的用途是什么?

What is the purpose of IMEX=2 in the above connection string?

推荐答案

来自连接字符串

如果您想将列标题读入结果集中(即使有标题也要使用HDR = NO)并且列数据是数字，请使用IMEX = 1以避免崩溃.

"If you want to read the column headers into the result set (using HDR=NO even though there is a header) and the column data is numeric, use IMEX=1 to avoid crash.

始终使用IMEX = 1是检索混合数据列数据的一种更安全的方法. .."

To always use IMEX=1 is a safer way to retrieve data for mixed data columns. .."

请注意，当您需要将数据写回Excel时，IMEX值可能非常重要. 在IMEX上的Internet上进行的快速搜索发现了许多有关各种IMEX值问题的文章

Please note that the IMEX value can be very important when you need to write back data to the Excel. A fast search on Internet on IMEX found numerous articles about problems with various IMEX values

这篇关于OLEDB连接字符串中的IMEX是什么?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！