What IMEX mean in connection string with Excel

[ad]

My Connection String for excel have some problem before, it can't read some
cells.
The old stirng is

***************************************************************
string sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=c:\\Health.xls;" +
"Extended Properties=" +
"Excel 8.0;IMEX=1;" ;
***************************************************************



After the guide of Paul, changing the string by add IMEX and (char)34, it
run well now.
But I do'nt know what IMEX mean
Can some one tell me!



***************************************************************
string sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=c:\\Health.xls;" +
"Extended Properties=" +
(char)34 + "Excel 8.0;IMEX=1;" + (char)34;
***************************************************************

 

[William Ryan eMVP]

It simply tells the driver that data that's intermixed should be treated as
text.


--
W.G. Ryan MVP Windows - Embedded

Have an opinion on the effectiveness of Microsoft Embedded newsgroups?
Let Microsoft know!
https://www.windowsembeddedeval.com/community/newsgroups

 

[ad]

What is intermixed in Excel?

It simply tells the driver that data that's intermixed should be treated as
text.


--
W.G. Ryan MVP Windows - Embedded

Have an opinion on the effectiveness of Microsoft Embedded newsgroups?
Let Microsoft know!
https://www.windowsembeddedeval.com/community/newsgroups

 

[Cor Ligthert]

What is intermixed in Excel?numbers, dates, etc etc

Cor