wierd problem

Results 1 to 3 of 3

Thread: wierd problem

  1. #1
    Join Date
    Dec 1969

    Default wierd problem

    I&#039;d asked how to export tables created in asp to excel so that i get them in printable format. I&#039;m able to do it .But i have a small problem.<BR> There is a field called BondNo in the table which is of the format --/-- (i.e 2 nums/2nums).When i give the field as 05/05,it gets displayed as 05/may in excel.It takes it as a date! even though i&#039;ve specified the data type as varchar in sql server

  2. #2
    Join Date
    Dec 1969

    Default RE: wierd problem

    yeah I know that problem!<BR><BR>only way I could do it was to put a single quote infront of the data

  3. #3
    Join Date
    Dec 1969

    Default Or, better, enclose it in quotes...

    Safest thing to do, anyway. Enclose all text fields in quotes.<BR><BR>

Posting Permissions

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