import excell with japanese charaters

[khalik_ash]

hi foks

i have a asp page where i import the excel data into my database. i am using "Microsoft.Jet.OLEDB.4.0" as Provider to open the excel file.

the problem is the excel file has japanes charaters.. now when i open with this provider i get only ...???? not the japanese charaters..
i got stuck with this problem any suggestions....
shd be a way out....

[khalik_ash]

Dont we have a solution for this.....

ado 2.7 i am able to do this.. but why not with Jet.OLEDB...

guys who worked on japanese stuff shd have some solutions...

[khalik_ash]

[BansheeTwin350]

I have a webpage that runs from and Access database. I am trying to set it up so users can upload records to the database by typing in the path to an excel file on their pc and then my asp page will read the excel file and add the records to the database. From you first post, I see that you know how to do this. I know what to do once I get the data from Excel, but before that I have no clue. Thanks for any help!!