Hi all,

The problem:
I am trying to copy data from a MS Access 2000 database to a SQL 7.0 database with VB 6.0. The data in the MS Access database is multi lingual that is the text fields are unicode. When I create the recordset for the table in Access I looze the unicode characters. They turn into "?" and are displayed on SQL as "?".

The question:
Is there a way to copy unicode data with VB 6.0 without loosing the unicode characters?
Is VB the tool for this or should I switch over to VC?

The solution:
Please fill in if you have any idea....