oledb connection string ignoring alpha numeric values.

Question

0.00/5 (No votes)

See more:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\SigmaFlow Projects\BPI\NewTFS\Insight\Insights Web\TempFiles\xbumrsw05bs53x52gojp0tayH\;Extended Properties='text;HDR=YES;IMEX=1;'

oledb driver filling data but ignoring the entire value which is cosist of alphanumeric.

actually ,when user import the excel file , it behave strange.Here I have a column which have alpha numer ,text and numbers, Oldeb driver check the majority of the value's datatypes, if it has 4 alpha numeric & 2 numeric, then it shows 4 alpha numeric & 2 nulls in place of 2 numeric, same situation will occured with the others fielfs.. it sees only the majority & then decide.

Posted 10-Dec-13 3:35am

Ali_100

Updated 12-Dec-13 23:19pm

v2

Add a Solution

Comments

thatraja 10-Dec-13 10:34am

Not clear, update your question with more clear details

CHill60 10-Dec-13 15:11pm

Your data source doesn't look right... there should be a database name at the end of all that gibberish not a backslash

Ali_100 13-Dec-13 5:16am

No that was not the issue with me,, I got a solution that to modify the registry in server.

CHill60 13-Dec-13 5:39am

Well I'm not convinced ... that connection string is wrong and you shouldn't have to make registry changes just to connect. However if you have found the solution then please post it for the benefit of others

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2013-12-12T23:43:00

Solution 1

Remove IMEX=1 from the end of connection string.
For further information, please, see: http://www.connectionstrings.com/excel/[^]

Posted 12-Dec-13 23:43pm

Maciej Los

Comments

pravallika5 20-Nov-17 3:15am

Am facing similar issue. Excel not reading any mixedtype values after 8 numereric values. Through some reserach found that need to make the changes in registry. But my company will not allow that to do. Do have any other workaround??
Below is my connection string:
<add name="Excel03ConString" connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties='Excel 8.0;HDR={1};IMEX=1;'" />
<add name="Excel07ConString" connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties='Excel 8.0;HDR={1};IMEX=1;'" />
Can someone help me?

Maciej Los 20-Nov-17 3:51am

Read my answer one more time. What is stated there? Remove "IMEX=1" from the end of connection string.

pravallika5 20-Nov-17 3:55am

Thanks Maciej, but removing IMEX didnt work! In the first 8 rows if i have any alphanumeric it is skipping that..