Project Description:
I am having a table available in excel format and features the subsequent:
- It has about 170000 rows
- Some text is longer than 255 in length.
- Some text is in Arabic
I used the already available Import from Excel to MSSQL Table accessible in SQL Server but it always trims the text if it is more than 255 chars in length.
I am looking for a solution to import the excel data completely without any chars trimming etc. Bidder might suggest developing a simple program for this, or any other feasible solution.
Skills required:
SQL, .NET