Excel and ASP

Results 1 to 2 of 2

Thread: Excel and ASP

  1. #1
    Join Date
    Dec 1969

    Default Excel and ASP

    Hai,<BR>I am accessing sheet1 in excel file which has 3 cells.The sample file is as below<BR><BR>t162775 TaxStatus Tax Exempt<BR>t162775 AcctType IRA<BR>t162775 BankAcct TCT-006969<BR>t162775 TaxIDOrSS 127608008<BR><BR>When the integer values appear in the 3rd column (for t162775) this excel driver does not return any value.(rather it returns a null instead of 127608008).I am using the code like this<BR>***********************************<BR>Set conn = Server.CreateObject("ADODB.Connection")<BR>conn.Op en "DRIVER=Microsoft Excel Driver (*.xls);" _<BR>& "DBQ=" & Server.MapPath("LabelData.xls")<BR>set rs = server.CreateObject("ADODB.Recordset")<BR>&#039; create and open the recordset<BR>rs.Open "Select * From [sheet1$]",conn,adOpenDynamic,adLockOptimistic<BR><BR>***** *****************************<BR>Is there anyway we can do this??<BR>Thanks in advance<BR>Ravi<BR>

  2. #2
    Join Date
    Dec 1969

    Default I am not sure about this...

    but could it be because it thinks that it&#039;s a string/number and it needs to be changed to a number/string?

Posting Permissions

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