Now, I want to create a Excel file using the object of Excel.Application in asp.
I retrieve field's value from SQL Server 2000(field's value is Traditional Chinese big5, nvarchar type) and fill it in Excel's cell, call [objExcel.ActiveWorkbook.SaveAs Server.MapPath("ExportExcel/"&strFileName)] to generate a new Excel file. but when I open the file, I find content is not displayed properly.
what shall I do? pls help me! thanks in advance.

The SAVEAS method has a parameter for the code page that you want to use.

Hi guy,
I have tried it, but it seems that it doesn't work... "Encoding" parameter only for saving text files.
see below content from MSDN:

expression.SaveAs(FileName, FileFormat, LockComments, Password, AddToRecentFiles, WritePassword, ReadOnlyRecommended, EmbedTrueTypeFonts, SaveNativePictureFormat, SaveFormsData, SaveAsAOCELetter, Encoding, InsertLineBreaks, AllowSubstitutions, LineEnding, AddBiDiMarks)

Encoding Optional MsoEncoding. The code page, or character set, to use for documents saved as encoded text files. The default is the system code page.