Click here to Skip to main content
15,884,176 members
Home / Discussions / C#
   

C#

 
GeneralRe: Better RichTextBox (or custom textbox) Pin
Stephane Rodriguez.1-Nov-02 7:07
Stephane Rodriguez.1-Nov-02 7:07 
GeneralPassword in a Propertygrid Pin
Andy Hampshire1-Nov-02 4:00
Andy Hampshire1-Nov-02 4:00 
GeneralRe: Password in a Propertygrid Pin
Stephane Rodriguez.1-Nov-02 7:12
Stephane Rodriguez.1-Nov-02 7:12 
GeneralRe: Password in a Propertygrid Pin
Andy Hampshire1-Nov-02 7:23
Andy Hampshire1-Nov-02 7:23 
GeneralRe: Password in a Propertygrid - HELP !! Pin
Andy Hampshire1-Nov-02 14:22
Andy Hampshire1-Nov-02 14:22 
GeneralRe: Password in a Propertygrid - HELP !! Pin
leppie1-Nov-02 21:16
leppie1-Nov-02 21:16 
GeneralRe: Password in a Propertygrid - HELP !! Pin
Feng Qin3-Nov-02 21:24
Feng Qin3-Nov-02 21:24 
GeneralNot able to fetch first row of excel...... Pin
Saroj31-Oct-02 23:33
Saroj31-Oct-02 23:33 
Hello Everybody,

I am trying to import data from Excel sheets through my application.But its not reding the first row of Excel sheet.

Somebody suggested me to set "HDR=No" property in my connection string.
So now my connection string looks as follows,

string strConn;
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source="+fullPath+";" +
"Extended Properties=Excel 8.0;HDR=No;";

but its giving me following exception

"System.Data.OleDb.OleDbException : Could not find
installable ISAM
at System.Data.OleDb.OleDbConnection.ProcessResults(Int32
hr)
at System.Data.OleDb.OleDbConnection.InitializeProvider()
at System.Data.OleDb.OleDbConnection.Open()
........"

To overcome this error i tried doing following things

I went to
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Excel

location in my windows registery and found following things,


Name Type Data

win32 REG_SZ c:\WINDOWS\System32\msexcl40.dll


then I checked if this "msexcl40.dll" really exist at the path c:\WINDOWS\System32
and it was present there.

Then i uninstalled office2000 from my machine and installed OfficeXP.
Still i am getting the same exception.

Can anybody help me in finding out where i am going wrong or what could be the problem?

Thanks in advance,

Regards,
Saroj

Saroj
GeneralRe: Not able to fetch first row of excel...... Pin
Stephane Rodriguez.1-Nov-02 1:59
Stephane Rodriguez.1-Nov-02 1:59 
Generalabout visual soucesafe6.0c Pin
Anonymous31-Oct-02 21:18
Anonymous31-Oct-02 21:18 
GeneralRe: about visual soucesafe6.0c Pin
TigerNinja_1-Nov-02 11:33
TigerNinja_1-Nov-02 11:33 
Generaldowncasting Object types Pin
Bilal31-Oct-02 20:33
Bilal31-Oct-02 20:33 
GeneralRe: downcasting Object types Pin
SimonS31-Oct-02 21:14
SimonS31-Oct-02 21:14 
GeneralRe: downcasting Object types Pin
Bilal31-Oct-02 21:19
Bilal31-Oct-02 21:19 
GeneralRe: downcasting Object types Pin
Eric Gunnerson (msft)1-Nov-02 12:01
Eric Gunnerson (msft)1-Nov-02 12:01 
GeneralRe: downcasting Object types Pin
John Fisher1-Nov-02 12:40
John Fisher1-Nov-02 12:40 
GeneralRe: downcasting Object types Pin
Bilal1-Nov-02 15:17
Bilal1-Nov-02 15:17 
GeneralRe: downcasting Object types Pin
Paul Riley1-Nov-02 0:23
Paul Riley1-Nov-02 0:23 
GeneralRe: downcasting Object types Pin
Feng Qin3-Nov-02 21:33
Feng Qin3-Nov-02 21:33 
GeneralMD5withRSA signature verification Pin
bluestn31-Oct-02 15:39
bluestn31-Oct-02 15:39 
GeneralCryptoAPI - Cryptography - Com Pin
delcorral31-Oct-02 12:33
delcorral31-Oct-02 12:33 
GeneralRe: CryptoAPI - Cryptography - Com Pin
ian mariano1-Nov-02 7:32
ian mariano1-Nov-02 7:32 
GeneralDelete/Copy files from another machine! Pin
KoRn31-Oct-02 9:41
KoRn31-Oct-02 9:41 
GeneralActive Directory Question Pin
Christian Merritt31-Oct-02 9:25
Christian Merritt31-Oct-02 9:25 
GeneralRe: Active Directory Question Pin
Nick Parker31-Oct-02 11:53
protectorNick Parker31-Oct-02 11:53 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.