locked
Importing Excel data (with Marathi fonts) in SQL Server 2008 RRS feed

  • Question

  • Hey,

    I have an excel files which contains Marathi (Indian) characters in one of the columns. I want to import contents of this excel (along with the column containing Marathi fonts) to a database in SQL Server 2008 R2. I know that data in a normal excel table can directly be imported into the SQL Server database, however that doesn't work with the Marathi characters.

    Any ideas?

    _A

    Thursday, November 17, 2011 10:22 AM

Answers

  • Hi amitabh247,

    Based on your description, I have imported data with Marathicharacters in excel to SQL Server 2008 R2 database with steps below:
    Right click the database – Tasks- Import Data.

    For the column with Marathi characters, you need to configure the column data type as nvarchar on the destination table by Edit Mappings. Below is the result imported form the excel:

     

    Best Regards,
    Stephanie Lv


    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    • Marked as answer by Stephanie Lv Thursday, November 24, 2011 9:03 AM
    Monday, November 21, 2011 7:46 AM