Export to excel in ASP

[mkavita]

Hi,
I am using ASP to export database data to excel file. However, the database table contains special charecters like Korean charecters which is not being exported to excel properly. Is there anyway to acheive this.

Thanks

[sashi]

Hi Kavita,

there are 2 types of code pages support by windows respectively.. you can try to change the current code page set in you ASP application at the moment.. good luck my fren.. take care.. :)

1st type..
SBCS (Single Byte Character Set) Codepages
• 1250 (Central Europe)
• 1251 (Cyrillic)
• 1252 (Latin I)
• 1253 (Greek)
• 1254 (Turkish)
• 1255 (Hebrew)
• 1256 (Arabic)
• 1257 (Baltic)
• 1258 (Vietnam)
• 874 (Thai)

2nd type..
DBCS (Double Byte Character Set) Codepages
In these graphical representations , leadbytes are indicated by light gray background shading. Each of these leadbytes hyperlinks to a new page showing the 256 character block associated with that leadbyte. Unused leadbytes are identified by a darker gray background.

• 932 (Japanese Shift-JIS)
• 936 (Simplified Chinese GBK)
• 949 (Korean)
• 950 (Traditional Chinese Big5)

[mkavita]

Hi,
I have used the following code in my ASP application but not successful.

<%@ CodePage=949 %>
<%
Response.Clear
Response.Buffer = true
Response.Conten tType = "applicatio n/vnd.ms-excel"
Response.AddHea der "Content-Disposition", "attachment ; filename= Registration_" & today1 & ".xls"
%>

Thanks and Regards
Kavita

Hi Kavita,

there are 2 types of code pages support by windows respectively.. you can try to change the current code page set in you ASP application at the moment.. good luck my fren.. take care.. :)

1st type..
SBCS (Single Byte Character Set) Codepages
• 1250 (Central Europe)
• 1251 (Cyrillic)
• 1252 (Latin I)
• 1253 (Greek)
• 1254 (Turkish)
• 1255 (Hebrew)
• 1256 (Arabic)
• 1257 (Baltic)
• 1258 (Vietnam)
• 874 (Thai)

2nd type..
DBCS (Double Byte Character Set) Codepages
In these graphical representations , leadbytes are indicated by light gray background shading. Each of these leadbytes hyperlinks to a new page showing the 256 character block associated with that leadbyte. Unused leadbytes are identified by a darker gray background.

• 932 (Japanese Shift-JIS)
• 936 (Simplified Chinese GBK)
• 949 (Korean)
• 950 (Traditional Chinese Big5)

[sashi]

Hi Kavita,

<%@ CodePage=949 %>

why is there an @ sign? remove it.. i think i should work fine..

well.. seems that your code segment is correct.. u have used the correct code page as well as document content type.. emm.. let me see.. do you have the korean font pack installed in your pc? check it out.. good luck my fren.. take care.. :)

[mkavita]

Hi,
I removed @ symbol from the code page still not working.I am not sure about the korean font. Please help.

Thanks and Regards
Kavita

[sashi]

Hi Kavita,

install the korean font pack.. that could be the problem.. since everything else is working fine.. i see no other problem except the font set.. good luck my fren.. :)

[mkavita]

Thanks for the help. It is working after installing the font. Once again, thanks a lot for the help.

[sashi]

Hi Kavita,

anytime buddy.. u need help?? no problem.. :) take care my fren..

[Renuga]

Hii
Does anyone has an idea on how to upload an excel sheet to the database if the excel sheet has fields exm:
Execution No:060.88.99.00 convert to a format without point characters
exm:060889900

Thanks