Find Jobs
Hire Freelancers

Application to Export Excel Data to MSSQL Server table

$30-250 USD

Cerrado
Publicado hace alrededor de 10 años

$30-250 USD

Pagado a la entrega
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
ID del proyecto: 5354326

Información sobre el proyecto

79 propuestas
Proyecto remoto
Activo hace 10 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
79 freelancers están ofertando un promedio de $115 USD por este trabajo
Avatar del usuario
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 en 2 días
4,9 (293 comentarios)
7,7
7,7
Avatar del usuario
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 en 7 días
5,0 (63 comentarios)
7,3
7,3
Avatar del usuario
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 en 3 días
5,0 (207 comentarios)
7,3
7,3
Avatar del usuario
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 en 4 días
4,9 (57 comentarios)
6,9
6,9
Avatar del usuario
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 en 1 día
5,0 (8 comentarios)
7,0
7,0
Avatar del usuario
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 en 3 días
4,9 (56 comentarios)
6,8
6,8
Avatar del usuario
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 en 1 día
5,0 (19 comentarios)
6,1
6,1
Avatar del usuario
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 en 1 día
5,0 (48 comentarios)
5,6
5,6
Avatar del usuario
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 en 3 días
4,9 (36 comentarios)
5,7
5,7
Avatar del usuario
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 en 2 días
5,0 (29 comentarios)
5,7
5,7
Avatar del usuario
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 en 1 día
5,0 (42 comentarios)
5,6
5,6
Avatar del usuario
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 en 3 días
4,8 (16 comentarios)
5,2
5,2
Avatar del usuario
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 en 2 días
5,0 (24 comentarios)
5,2
5,2
Avatar del usuario
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 en 2 días
5,0 (9 comentarios)
5,1
5,1
Avatar del usuario
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 en 7 días
4,5 (26 comentarios)
5,2
5,2
Avatar del usuario
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 en 3 días
5,0 (34 comentarios)
4,6
4,6
Avatar del usuario
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 en 1 día
5,0 (7 comentarios)
4,3
4,3
Avatar del usuario
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 en 1 día
4,6 (19 comentarios)
4,8
4,8
Avatar del usuario
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 en 5 días
5,0 (7 comentarios)
4,1
4,1
Avatar del usuario
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 en 2 días
5,0 (4 comentarios)
3,8
3,8

Sobre este cliente

Bandera de OMAN
Muscat, Oman
4,4
107
Forma de pago verificada
Miembro desde mar 25, 2012

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.