Hi.

In Norway we have some special letters not used in other languages (ÆøÅ). In SQL200 we had to use ODBC if we wanted to import (from Excel) these letters correctly into the database. In SQL2005 I can not find the ODBC destination option in Import/Export Wizard, and if I use OLEDB or some other option the special letters get messed up.

Anyone have an idea how to get this done in 2005?

Gert

When you use OLEDB is your destination column nvarchar, nchar, ntext or is it varchar, char, text?
If one of the latter then use one of the former.

Let us know how that works.

David Lundell
Principal Consultant and Trainer
www.mutuallybeneficial.com

Hi David.

The destination column was varchar. I tried out your suggestion, imported to an nvarchar column first, and then inserted into the table with the varchar column. This worked fine :)

Thanks a lot.

Best regards
Gert