What is IMEX within OLEDB connection strings?

c# connection-string oledb
Dimitar Tsonev picture Dimitar Tsonev · Apr 11, 2012 · Viewed 75.3k times · Source

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

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

Answer

Steve picture Steve · Apr 11, 2012

From ConnectionStrings

"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.

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

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

Related questions

Microsoft.ACE.OLEDB.12.0 CSV ConnectionString

I know questions this kind are asked from time to time but i can't find any satisfying solution. How can I open a CSV-File using MS ACE OLEDB 12? I try it with the following code. DbConnection connection = new OleDbConnection(); connection.…

Read More
How can I set an SQL Server connection string?

I'm developing a simple C# application, and I'd like to know this: When I connect my application to SQL Server on my PC, I know the connection string (server name, password, etc.), but when I connect it to another PC, …

Read More
Get connection string from App.config

var connection = ConnectionFactory.GetConnection( ConfigurationManager.ConnectionStrings["Test"] .ConnectionString, DataBaseProvider); And this is my App.config: <?xml version="1.0" encoding="utf-8" ?> <configuration> <connectionStrings> <add name="Test" connectionString="Data Source=.;Initial Catalog=OmidPayamak;Integrated Security=True" …

Read More