SQL Server Import Character Encoding Excel

Question

So I am doing a SQL Import via Sql Server Import and Export Wizard with an Excel spread sheet and the following happens:

Veubroncé comes in as Veubroncã‰

Any way to avoid this?

Anthony Faull · Accepted Answer · 2011-06-14 08:13:59Z

2

This happens when UTF-8 encoded text is interpreted as ANSI encoded text. Are you sure you're not importing a CSV text file rather than Excel? Open the CSV file in Notepad and change the encoding to "UTF-8 with signature".

answered Jun 14, 2011 at 8:13

Anthony Faull

18.1k5 gold badges58 silver badges75 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL Server Import Character Encoding Excel

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related