How to transfer Right-to-Left text from Excel to SQL Server? I have a collection of data in my Excel which the language is right-to-Left. My data collection is very large. I want to transfer this to my SQL Server database and insert the values into a table.

For example it would be like this:

Insert City (Id, City, State_Id)
values (1, N'right-to-left text', 5)


Right-to-Left sample :    (2, N'تهران')   

As you might be aware the prefix N is used to describe the character.

My question is how would I be able to transfer all this data without having to overwrite them again?

The main problem is the right-to-left characters
There are two ways to perform this:


Right click on Database -> Task -> Import Data -> Select Excel as your data source ->     continue until the wizard is finished .
The longgest way:


In Excel add the following Columns before your data as follow:






Copy and paste your data set in a new query on SQL Server.

Use Ctrl + H to replace the blank spots like follow:




format it as you like and you're good to go!