greetings! i am an average programmer with about 2 years of experience in VB6. i am to develop a DLL that parses the contents of an excel file and upload it to a remote database...

the 1st problem i had was that when i parse non-string values in the cells i get a "null value", i have solved (tempoarily) by adding letters on the string so that ADO then treats it as text, as i was browsing the INet i have stumbled upon setting ISAM to "1" so all datatypes could be read properly.

*************** START HERE ******************

' >>>>> THIS WORKS!!!

With oConn
.Provider = "Microsoft.Jet.OLEDB.4.0"
.ConnectionString = _
"Data Source=C:\manuel327.xls;Extended Properties=Excel 8.0;HDR=NO;"
.CursorLocation = adUseClient
.Open
End With

' >>>>>> ERROR!!!
With oConn
.Provider = "Microsoft.Jet.OLEDB.4.0"
.ConnectionString = _
"Data Source=C:\manuel327.xls;Extended Properties=Excel 8.0;HDR=NO;ISAM=1"
.CursorLocation = adUseClient
.Open
End With

*************** END HERE ********************


The problem is that when i append those properties i get a weird "COULD NOT FIND INSTALLABLE ISAM" error

can someone please help me?

thanks in advance...

URL: http://support.microsoft.com/default...b;en-us;257819

i have seen from this URL that the only way for me to get this error is when i try to used jet 3.51 because jet 3.51 does not support these properties... but as you can see i have posted the code above and i still receive the error even if i declare to use Jet 4.0

why???

pls help...

URL: http://support.microsoft.com/default...b;en-us;257819

i have seen from this URL that the only way for me to get this error is when i try to used jet 3.51 because jet 3.51 does not support these properties... but as you can see i have posted the code above and i still receive the error even if i declare to use Jet 4.0

why???

pls help...

Please, test this code

With cnn
.Provider = "Microsoft.Jet.OLEDB.4.0"
.ConnectionString = "Data Source = " & _
Path & ";" & _
"Extended Properties=""Excel 8.0; HDR=Yes;"""
'"Extended Properties=Excel 8.0;"
.CursorLocation = adUseClient
.Open
End With