|
|
 |
| SQL Server 2005 General discussion of SQL Server *2005* version only. |
Welcome to the p2p.wrox.com Forums.
You are currently viewing the SQL Server 2005 section of the Wrox p2p Programmer to Programmer discussion community. This is a community of more than 40,000 computer programmers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining our free Wrox p2p community you can post your own programming questions and respond to other programmers’ questions. Registered users also don't have to see the ads that are displayed to guests. Registration is fast, simple and absolutely free so please, join today!
Join today and post to win prizes! Post more to increase your chances of being Wrox’s top poster of the month.
|
 |
March 27th, 2006, 06:09 AM
|
|
Authorized User
|
|
Join Date: Jun 2003
Location: , , Norway.
Posts: 95
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Import Wizard trouble in 2005
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
|
March 27th, 2006, 10:17 PM
|
|
Friend of Wrox
|
|
Join Date: Dec 2005
Location: , AZ, .
Posts: 146
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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 |
March 28th, 2006, 06:37 AM
|
|
Authorized User
|
|
Join Date: Jun 2003
Location: , , Norway.
Posts: 95
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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
|
| Thread Tools |
Search this Thread |
|
|
|
| Display Modes |
 Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
|
