ADO-Unable to retrieve type "Memo" field from Access DB

Hi,

I have a strange problem!!!

Situation:

• I have built a system with Excel front-end and Access DB as back-end (both Ver 2000)
• I have an ADO connection to Access DB.
• I build select queries from Excel VBA and try to get data.
• I have three type "MEMO" fields in my DB.

Problem:

• When I use "SELECT (*)", I get the data to record set and then I dump it to another excel, It works great
• Instead if I use, "SELECT TableName.Memo1", then I get jumbled data and looks like some chinese font or character
• If I change the type from "MEMO" to "TEXT", it works fine. But, if "select*" is working fine with "memo", why not this?

Any suggestion is greatly appreciated...

Thanks,