Looking for a solution to import the excel data, DOT NET Programming

Assignment Help:

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


Related Discussions:- Looking for a solution to import the excel data

Decrypt data encrypted with visual basic, I've some encrypted data list of ...

I've some encrypted data list of customers that are stored in a sql server db. These data are encrypted using visual basic, using a specific dll, from what I could see. The work

What do you mean by data encapsulation, What do you mean by data encapsulat...

What do you mean by data encapsulation? Data encapsulation is a method of binding data and code in single unit known as object and hiding all the implementation details of a cl

DESIGN CALENDAER, HOW TO DESIEN THE CALENDER IN ASP . NET

HOW TO DESIEN THE CALENDER IN ASP . NET

Difference between "optimistic" and "pessimistic" locking, What's differenc...

What's difference between "Optimistic" and "Pessimistic" locking? In the pessimistic locking when user wants to update a data it locks the record and till then no one can updat

Differentiate between managed and unmanaged code, Differentiate between man...

Differentiate between managed and unmanaged code? Managed code is the code that is implemented directly by the CLR instead of the operating system. The code compiler first comp

Describe what are streams in file handling, Question : (a) Describe wh...

Question : (a) Describe what are streams in file handling and explain what should be done when accessing data in an existing file. (b) For what purpose are StreamReader an

Windows 8.1 project - asset management slate app, I need Windows 8.1 Projec...

I need Windows 8.1 Project, Asset management slate App Project Description: We are seeking a Windows 8 app developer with PROVABLE experience to prepare a project and asset m

I need isometric exploration tablet game, I need Isometric Exploration Tabl...

I need Isometric Exploration Tablet Game I am endeavoring to build an 2D tile-based isometric game, primarily for Android and iOS tablet devices. It will be built in Unity 3d v4

Do webservice have state?, Webservices as such do not have any mechanism by...

Webservices as such do not have any mechanism by which they can maintain their state. The Webservices can access ASP.NET intrinsic objects such as application, session and many mor

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd