Hello people,

Im stuck in a screen that i have to make... Its a "import screen"... Import a excel file to the database.. ok.. seems quite simple..

But i dont know why, saleslogix reads the fields and return blank... but they arent... The field have data...........Someone know a way to fix that?

The code is:

<p> 
 

 'Open Excel Driver

    Set ObjConn = CreateObject("ADODB.Connection")
    sProvider = "DRIVER=Microsoft Excel Driver (*.xls);" & "DBQ=" & sPath
    objConn.Open sProvider

    If err.number <> 0 Then
       ErrorCheck("SalesLogix could Not open Microsoft Excel Driver. Please, close this window and try again.")
       err.number = 0
       Exit Function
    End If

 

 'Open Excel Table
 strSQL = "SELECT NAME, TITLE from [Plan1$]"
 Set objRS = objConn.Execute(strSQL)

 While Not (objRS.EOF or objRS.BOF)

      .Fields("CUST_NAME").Value = objRS.Fields("NAME").value
      .Fields("CUST_TITLE").Value = objRS.Fields("TITLE").value

      objRS.MoveNext
 Wend

 

 But this field (   objRS.Fields("TITLE").value   ) returns blank... And in the excel file is not blank... someone can help?

thanks!

Rafael

nobody?

Hi Rafael,

I think u just try to comment the name field and try to execute .Then u should be able to read Title.

Thanks

Deepika

I have already did this.... dont work... Im thinking in change the read method...im using ADODB..i dont know if SLX reads in other ways, but i will search...if you know, end to me please...

thanks

Rafael

Hello Everyone!!! I found a solution...

I changed the Query that i was using and include the CStr function to convert the field do String....it works ..

My query to get the data from Excel is this:

  strSQL = "SELECT NAME, CStr(CODE) as VCODE, JOB, SECTOR, PHONE from [Plan1$]"

thanks for all who tried to help me!

Rafael S.