Unicode recordsets in VB

[AdrianBuzgau]

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....

[Lothar Haensler]

did you check out the Data Transformation Services in SQL Server 7?
if you really only copy data from Access to SQLServer you shouldn't have to write a single line of code.