Add record in excel through asp in chinese character and read two workbooks.

[milton ning]

Hi,

I am new to asp. I use the excel as database in asp. First, I want to know how to add records in excel through asp. Second, I try to show the data in web page (asp), it doesn't work if the data is in Chinese character in excel file. Third, I want to read two different workbooks through asp. How can I do?

Please tell me. Thanks a lot!

Milton

[jhardman]

First, try looking through our our article section, the methods listed there for adding records will work with excel, I have done that in the past. You will want to use microsoft jet oledb provider.

For displaying chinese characters in an asp page, this is a difficult question and one that many people have trouble with. I personally have never tried, but I know it works better if you send out the characters as a binary data stream rather than as a text stream.

Let me know if that helps.

Jared