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

Timer, what is timer control

what is timer control

What is the difference between vb.net and c#?, Difference between VB.NET an...

Difference between VB.NET and C# This is the main debatable issue in .NET community and everyone treat their languages like religion. It is a very important matter which lan

Define inheritance, Can you define what inheritance is and an example of wh...

Can you define what inheritance is and an example of when you might use it? The process of deriving a new class from an existing class is known as Inheritance. The old class is

Asp .net facebook app project completion, Project Description: We are a ...

Project Description: We are a small development house in Singapore, and have a project which is 90 percent complete; thud our previous developer could not finish due to other co

Why do we use the xmlhttprequest object in ajax, Why do we use the XMLHttpR...

Why do we use the XMLHttpRequest object in AJAX? The XMLHttpRequest object is used by JavaScript to transfer XML and other text data among client and server. The XMLHttpRequest

A bot and php command panel, Deat Sir/Madam, I need a small software .NET2...

Deat Sir/Madam, I need a small software .NET2.0 in C# That search for files by - name - extension - part of the name (contains) - file created before a date provided This search

Ways to implement locking in ado.net, What are the ways to implement lockin...

What are the ways to implement locking in ADO.NET? There are many ways to implement locking using ADO.NET which are shown below:- 1)Whenever we call "Update" method of DataA

Define the term viewstate as used in the asp.net framework, Problem: (a...

Problem: (a) Define the term ViewState as used in the ASP.NET framework. (b) What is a StateBag class? Give a simple example to support your answer. (c) (i) Distingui

How many types of generations are there, How many types of generations are ...

How many types of generations are there in a garbage collector? Memory management in the CLR is separated into three generations that are building up by grouping memory segment

Explain dataset accept changes, Explain Dataset Accept Changes and Data Ada...

Explain Dataset Accept Changes and Data Adapter Update methods?  Data Adapter Update method Calls the respective INSERT, UPDATE, or DELETE statements for each inserted, updated

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