Closed

Application to Export Excel Data to MSSQL Server table

Hi

I am having a table available in excel format and features the following:

- It has about 170000 rows

- Some text is in Arabic (e.g. UTF-8 encoding)

- Some text is longer than 255 in length.

I used the already available Import from Excel to MSSQL Table available 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 fully without any chars trimming etc. Bidder might propose developing a simple program for this, or any other feasible solution.

Attached is a sample excel file

Many Thanks

Skills: .NET, SQL

See more: sql table, excel to application, mssql having, mssql, export from excel, excel to sql, excel -data, data encoding, c# MSSQL, arabic excel , arabic application, sql server import text, text file import sql server, simple net excel application, net excel import, net import export, application mssql, data export net, net import excel, always mssql, mssql excel, excel import export, export sql table excel, excel text rows, export sql

About the Employer:
( 96 reviews ) Muscat, Oman

Project ID: #5354326

85 freelancers are bidding on average $116 for this job

AnisInfoTech

Hello, We can do that , what should be deliverable ? You send us that excel sheet and will give you MSSQL db backup ? Regards, AIT Team

$252 USD in 7 days
(42 Reviews)
6.9
customizedata

I have also made a tool like this for two databases. i can share the screenshots with you.i can modify it for excel. characters greater than 255 length will also be moved.

$100 USD in 3 days
(91 Reviews)
6.1
coderPros

Hello There, Before I go into greater detail regarding my skills and experiences, I'd like to take a moment to talk about your specific requirement: This sounds like a fairly straight forward project. I've been More

$105 USD in 2 days
(24 Reviews)
5.6
kalpesh2804

Hello, I have experience in EXCEL to MSSQL Conversion. i want to discuss with you project detail. my program will work without MS Office. thanks Kalpesh

$150 USD in 4 days
(39 Reviews)
5.5
feninsoftech

Hi, It seems column length is smaller than excel column data length. This can be resolved my altering column length to MAX in SQL Server. I have 8.5 years experience in SQL Server 2005|2008|2008R2|2012 and involv More

$155 USD in 3 days
(16 Reviews)
5.3
mrkrunaldoshi

I am Krunal K. Doshi from Ahmedabad, having 10+ years of experience in web and windows development. We work on Microsoft technologies including Azure and Open source technologies like PHP and MySQL. We have gone th More

$160 USD in 3 days
(15 Reviews)
5.2
truongngocthanh

Dear Sir, I can do it right now. I will write a store procedure to import your data to MS SQL server will all information in your excel file. Best regards Thanh

$45 USD in 1 day
(28 Reviews)
5.2
zamoldar

Hello, I can start right now, I will use better column type for long string which version is sql server? I can create a c# application that import excell data to sqlserver Regards Hakan Yurt

$111 USD in 1 day
(14 Reviews)
5.1
tamerelanwer

Dear Sir, As I understood, you got a problem with exporting text from excel to MS SQL Server. I believe the problem is with the database itself. Due to the column size in the database table, it only accepts 255 char More

$50 USD in 2 days
(10 Reviews)
5.1
aaravsoft

Hello, I have an 12 years of experience in .net technology with C#.Net, VB.Net, Asp.Net, Kendo UI, Asp.Net MVC with Sql Server, MySql, Oracle and Access. I have also same experience in HTML5, Css, Jquery and Ja More

$50 USD in 1 day
(35 Reviews)
5.0
anishbhatia

Hi! I can develop simple application to import your Excel data into SQL Server. Please provide the structure of the SQL table also. Application will import all your data into sql server including data which has more More

$166 USD in 2 days
(7 Reviews)
4.9
manhpham

Hi there. I am senior developer from Vietnam. I have been working on this site for 2 years. I am interested in your [url removed, login to view] let's me help you.

$45 USD in 2 days
(29 Reviews)
4.8
NehaliAmin

Hello, I am expert of developing applications which reads data from excel files and write it to SQL Server. I have also experience in handling arabic characters. I can develop a .NET application for you which More

$45 USD in 1 day
(18 Reviews)
4.7
elboukharimu

Salam Alaykom Akhi, I'm very interested helping you exporting your Excel data, I have more then 7 years of experience in SQL and database administration, modeling, optimizing and manipulating, please do not hesitate to More

$210 USD in 7 days
(16 Reviews)
4.6
wesolvevw

Hello, What is your SQL Server version. I have multiple options to do this. Can you please share your table schema also. I will try importing and let you know the easiest solution on success. Thanks

$55 USD in 3 days
(34 Reviews)
4.5
yeki

I am an expert .NET developer with more than 9 years of experience. I can develop a small app for you to import that excel file to ms sql table. Please see my profile and consider my bid.

$150 USD in 2 days
(17 Reviews)
4.5
gjinfotech004

hello I am c# developer. I will create desktop application that will convert your xlx to sql datatable I am c# developer having 5 year experience. thank you [url removed, login to view] is my Skype

$122 USD in 1 day
(6 Reviews)
4.4
arhamsoftltd

Dear Sir, There is no need to write any program, My developer has already searched and found the solution. I can help to increase the length to 8000 characters. Please don't forget to visit our profile to see the More

$79 USD in 1 day
(5 Reviews)
4.3
murtaza1981

Hi, An ASP.NET,c#,vb ,SqlServer,JQuery,Javascript expert here. Please feel free to discuss the project with me so that i can wrap it up in a timely manner as per your requirements. I would like to highlight following More

$300 USD in 5 days
(8 Reviews)
4.3
Prateekagra

hi i have 7 year of experience i can do this for you please let me know when we can discuss the same

$155 USD in 3 days
(7 Reviews)
4.2