Hi there,

(Just a note, I have already posted this at
microsoft.public.il.hebrew.sqlserver with no response yet)

I am trying to import an Access 2000 database with Hebrew characters in some
of the fields to a SQL Server 2000 database.

I tried to do it using dts, and it worked, there is just one problem. I am
doing this for a pre-existing database, and there is already data in the
tables which works great for the rest of the site. However, when the data is
imported, it messes things up.

Originally, the data appears gibberish in SQL Server, while in Access it
appears as Hebrew text. When I import, it appears as Hebrew text. However,
the site only renders the text as Hebrew when it appears gibberish in SQL
Server not when it appears like Hebrew in the server.

Any help would be greatly appreciated.

Thank you.