Find Jobs
Hire Freelancers

Application to Export Excel Data to MSSQL Server table

$30-250 USD

Closed
Posted about 10 years ago

$30-250 USD

Paid on delivery
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
Project ID: 5354326

About the project

79 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
79 freelancers are bidding on average $115 USD for this job
User Avatar
Hello, I am very much interested to do this job. I am experienced a lot in .Net as well as ms sql server. I want to develop a simple vb.net tool for this task, i already did similar type of work. I hope i can do it efficiently. Looking forward to have a positive response from you. Thanks
$32 USD in 2 days
4.9 (293 reviews)
7.7
7.7
User Avatar
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
5.0 (63 reviews)
7.3
7.3
User Avatar
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
5.0 (207 reviews)
7.3
7.3
User Avatar
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
4.9 (57 reviews)
6.9
6.9
User Avatar
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 portfolio and our client's reviews about our work. Hope to hear from you soon. Best Regards Zeeshan A.
$79 USD in 1 day
5.0 (8 reviews)
7.0
7.0
User Avatar
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 involve in designing databases, Indexing Strategies, table partitioning, writing Stored Procedures, Triggers, functions and views. I have expertise in writing complex queries with proper joins and index selection. In past, i involved in balancing between concurrency and locking and lock escalation. Microsoft Certified Technology Specialist in SQL Server. Thanks, Ajay
$155 USD in 3 days
4.9 (56 reviews)
6.8
6.8
User Avatar
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
5.0 (19 reviews)
6.1
6.1
User Avatar
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
5.0 (48 reviews)
5.6
5.6
User Avatar
Experienced programmer with more than 10 years of development experience here. I have handled production applications with various technologies like .NET, PHP, Classic ASP and many more using databases like MySQL, Microsoft SQL, Access and etc. Mentioned below are a few USPs for choosing me: 1. Well written codes with proper documentation 2. Highest possible code optimization 3. Quick support through email / skype / telephone 4. Daily / Weekly status reporting Let's discuss and make this project a success. Regards, Hardik Shah
$100 USD in 3 days
4.9 (36 reviews)
5.7
5.7
User Avatar
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 developing software applications for over 14 years now and can have this ready for you by tomorrow afternoon. I do have one question, however... You mentioned that you already have an app that does this, but it is truncating the data. Are you certain that the MAXLENGTH in the destination database is not 255 characters in length? I just wanted to confirm this before we go through the trouble of developing the app, if you don't actually need it. I have been developing web and software solutions for well over a decade now. I've worked with companies and government agencies around the world. I'm an American, but reside in Europe at least half of every year. One of our most significant value-adds is that I have significant knowledge on how business is conducted around the globe, specifically as it pertains to Information Technology. Provided that we have staff in America and Europe, we can offer a 24 hour development schedule for clients that are so inclined, either augmenting your own staff or providing/sourcing our own. Thank You, Brandon Osborne "Done Right the First Time!"
$105 USD in 2 days
5.0 (29 reviews)
5.7
5.7
User Avatar
Dear Sir, Its 2nd time i do a bid on your project and you did send me a reply, I'm good freelancer at SQL, please check the other project I've send you a video, also i can help you with Arabic stuff as I'm Egyptian. Give me chance Sir. Kind Regards, NourElDeen
$50 USD in 1 day
5.0 (42 reviews)
5.6
5.6
User Avatar
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 through your requirements and understand that you will like to have an application which imports data from excel to SQL Server. In this project we need to take care of collation for handling Arabic text. We are confident of delivering this project successfully and making it memorable for you. We look forward to establish strong relationship with our clients lasting more than a project. Let us know your concerns if any so that we can move ahead.
$160 USD in 3 days
4.8 (16 reviews)
5.2
5.2
User Avatar
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
5.0 (24 reviews)
5.2
5.2
User Avatar
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, therefore you should change the size to MAX or maybe you should change also the column datatype. This is a very quick investigation according to the problem description you provided. If you accepted my bid I could fix it within 24 hours of bid acceptance and giving me access to the database. Please feel free to contact me for further details. Regards Tamer Khalil
$50 USD in 2 days
5.0 (9 reviews)
5.1
5.1
User Avatar
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 check my portfolio, there is some samples of databases modeling and database assignments. I've checked your requirement I can do this job in the deadline without a problem, because I've done many projects like this. Please send me all other details about your project, so we can start asap. I'm available, and can start immediately. Looking forward to working with you. Thank you for your consideration. Regards
$210 USD in 7 days
4.5 (26 reviews)
5.2
5.2
User Avatar
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
5.0 (34 reviews)
4.6
4.6
User Avatar
Hi, I can help you out in this but need to know few things first. Do you want it once for this excel file only? Does table already exists in the database? What happen if records already exists, do you want to check that? Did you try using SSIS, and update the mapping? Which version of SQL do you have? I can propose two solutions, either we can use SSIS and provide the mapping for the table or create an desktop application and using bulk copy we can insert all records. Thanks, Arbab
$80 USD in 1 day
5.0 (7 reviews)
4.3
4.3
User Avatar
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 can do this quickly and in satisfactory manner. Thanks, Nehali
$45 USD in 1 day
4.6 (19 reviews)
4.8
4.8
User Avatar
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 qualities of me why you would love to work with me. 1) Has an eye for detail and places heavy emphasis on end user experience. Bringing more value to the table is the utmost priority of my career goal. I believe in continuous progress and rapid upkeep with latest technology is the key to thrive. 2) My focus is on doing high quality work. I am finding an individual approach to each new job and do it professionally, quickly, qualitatively, paying attention to even the smallest details. 3) The most important thing for me is a quick and quality work. 4) I specialize in making things intuitive, engaging and enjoyable. 5) Programming is not only my job but it is also one of my hobbies. Coding is fun for me and my goal is to always exceed the expectations. I try to compete on quality not quantity or price with the other programmers. 6) You will get perfect end result of work on time and you will be satisfied with the end product. I would like to have a detailed document of your requirements so that we can discuss the each and every point in details. Thanks, Murtaza
$300 USD in 5 days
5.0 (7 reviews)
4.1
4.1
User Avatar
What is the Varchar for that column in SQL Server ? If it is more than 255 it will still save it. By default when you query it shows 255 chars, how you are querying it ? If you are querying from SQL Management Studio, got to tools > Options > Query Results > Sql Server > Results to text..check how much you have set there for maximum no of characters in each column...this may solve your issue.
$35 USD in 2 days
5.0 (4 reviews)
3.8
3.8

About the client

Flag of OMAN
Muscat, Oman
4.4
107
Payment method verified
Member since Mar 25, 2012

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.