Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2003
    Posts
    4

    Unhappy Unanswered: reading .xls file, when added HDR & IMEX to extended properties i get error

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


  2. #2
    Join Date
    Aug 2003
    Posts
    4
    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...

  3. #3
    Join Date
    Aug 2003
    Posts
    4
    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...

  4. #4
    Join Date
    Oct 2002
    Posts
    19
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •