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,