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

Convert an existing flash file into html5, Project Description: We are s...

Project Description: We are seeking a simple tool that can convert an existing flash file (.SWF) into HTML5. Our idea is to convert small flash games into html5 games. Please NO

What is a node, What is a node? A network can have of two or more compu...

What is a node? A network can have of two or more computers directly linked by some physical medium such as coaxial cable or optical fiber. Such a physical medium is known as L

Steps of acquiring a proxy object in webservice, What are the  steps of a...

What are the  steps of acquiring a proxy object in Webservice? The following steps are required to get a proxy object of a webservice at the client side:- 1.     The Clie

What is the appfabric component, What is the AppFabric component? The A...

What is the AppFabric component? The AppFabric component is used to make access control and dole out messages across clouds and enterprises. It has a service-oriented architect

Use of connection object, What is the use of connection object? The con...

What is the use of connection object? The connection objects are used to connect a data to the Command object. 1)An OleDbConnection object is used with the  OLE-DB provider

Sequence in which asp.net events are processed, What' is the sequence in wh...

What' is the sequence in which ASP.NET events are processed? The sequence in which the ASP.NET events occur are as folows :- 1.     Page_Init. 2.     Page_Load. 3.

Design consideration to take datagrid, How to decide on the design consider...

How to decide on the design consideration to take a Datagrid, datalist or repeater? So many make a blind choice of choosing datagrid directly, but that is not the right way.

Calculating the sum of digits - c# program, Calculating the Sum of Digits -...

Calculating the Sum of Digits - C# Program Hi, Can any of you, tell me how can i calculate the sum of digits of a given number?

Types of compatibility in vb6, What are types of compatibility in VB6 T...

What are types of compatibility in VB6 There are three possible project compatibility settings: No Compatibility Project Compatibility Binary Compatibility

Downloadable software for a pc computer and mac, Downloadable software for ...

Downloadable software for a PC computer and Mac Project Description: "The software" can be sold as a downloadable purchase. I must have all copy rights to "the software" when

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