Results 1 to 3 of 3

Thread: osql utility

  1. #1
    Join Date
    Jul 2004
    Posts
    34

    Unanswered: osql utility

    Hi all
    I am using osql utility in sql server 2000 to convert data in database to excel sheet. My datas contain both english and chinese . While converting to excel sheet english datas are comming but the datas in chinese is comming like (?) this. Does any body has any idea to solve this problem. is there any way to set font in osql utility.

    set @x = 'osql -S servername -U username -P password -q "select * from

    northwind..region" -w 3000 -s "," -o C:\Download\download.csv'
    This is what i have used.
    Note: I tried giving chinese font in excel still it is not working.
    Its really urgent pls reply
    thanks

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Have you tried using the -u parameter of OSQL.EXE to force Unicode output? That would be needed for Chinese characters.

    -PatP

  3. #3
    Join Date
    Aug 2004
    Location
    Rayleigh, Essex
    Posts
    6

    Exclamation Excel

    What version of Excel are u using Have u turned on Multilingual

Posting Permissions

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