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

Perform arithmetic operations - c# program, Perform Arithmetic Operations -...

Perform Arithmetic Operations - c# Program Hello, i didn't find the correct way of using arithmetic operations in c#. I am beginner for this language. Please suggest me some e

What is common language specification, What is Common Language Specificatio...

What is Common Language Specification (CLS)? CLS is a set of essential rules, which must be followed by each .NET language to be a .NET- compliant language. It enables interope

Wrapper for ffmpeg, Help with making a wrapper in c# for ffmpeg to extract ...

Help with making a wrapper in c# for ffmpeg to extract audio from video

Calculate and display the volume of the sphere, Question: (a) Define f...

Question: (a) Define four special target names use with the TARGET attribute. (b) Assume that you have a document with many subsections. Write the HTML code to create a fr

Asp.net authentication process, Can you explain how the ASP.NET authenticat...

Can you explain how the ASP.NET authentication process works?   The ASP.NET does not run by itself, it runs inside the process of the IIS. So there are 2  authentication layer

Iuknown interface, Describe IUKNOWN interface All COM object supports a...

Describe IUKNOWN interface All COM object supports atleast one interface, that is  IUnknown interface. All interfaces are the classes, derived from the base class IUnknown. Eve

Methods provided by the command object, What are the methods provided by th...

What are the methods provided by the command object? The command objects used to connect the connection object to the Datareader or the dataset. The command object provided som

Create a xslt and css file, Using the attached XML file (xml_ind.xml) creat...

Using the attached XML file (xml_ind.xml) create a XSLT and CSS file for the following information: select the following information for ONLY the cars that cost more than $50,00

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