Find Jobs
Hire Freelancers

SQL data conversion - Excel to SQL Server

$30-250 USD

Completed
Posted over 8 years ago

$30-250 USD

Paid on delivery
This project is a data conversion from excel into SQL server via SQL scripts. The process of importing should be repeatable so that a user can import the attached excel file into a new table, run SQL conversion scripts and proper existing tables will be populated. The winner of this project will be able to: 1 - Review, learn and understand provided Route Manager DB field definitions, diagrams and field mappings with screenshots material provided. 2 - Restore empty db and sample db .bak files to their own SQL server. Sample test db is provided to see how data is inserted into various tables. 3 - Import CUST data spreadsheet into a SQL tmp table 4 - Write SQL scripts to correctly move data from excel into various SQL tables in the Empty db. 5 - For this conversion customer data needs to be mapped into CUST SQL table and related tables (UDEF and DBINI).
Project ID: 8319352

About the project

42 proposals
Remote project
Active 9 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
Awarded to:
User Avatar
Hi, I have 10 years of industry experience in C#, VB.net, SQL Server, Oracle and mySQL.. I have been using SQL Server as database for the last 10 years. I can import the Excel data into your database using SSIS (SQL Server Integration Services). I appreciate if you can send the sample excel data which you want to import so i can check and let you know if case of any question. I look forward to hearing from you. Regards, Farooq
$177 USD in 3 days
5.0 (19 reviews)
5.6
5.6
42 freelancers are bidding on average $171 USD for this job
User Avatar
Hello Sir, I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel and SQL. I am an Engineering Graduate with an MBA degree. If you see I am the niche bidders who has full 5 star rating, zero failed projects and very high completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. I will provide you with a working version of file before you consider awarding me the project. Thanks, Jay
$210 USD in 7 days
5.0 (509 reviews)
8.4
8.4
User Avatar
A proposal has not yet been provided
$250 USD in 5 days
4.9 (167 reviews)
7.1
7.1
User Avatar
Hello Dear, I can do this for you. Please send a massage in the PMB for details.......Best Regards flashsaiful
$155 USD in 3 days
4.9 (113 reviews)
6.6
6.6
User Avatar
Hi Sir/Madam. I will create a program for you to do this. Ready to start. Thanks. *** I will pay 15% penalty if the project is not completed on time ***
$155 USD in 3 days
5.0 (120 reviews)
6.6
6.6
User Avatar
A proposal has not yet been provided
$111 USD in 3 days
4.9 (74 reviews)
5.8
5.8
User Avatar
Hello, I'm interested in your project. Would like to help. What MS SQL Server version do you use? Will excel file be located on the server? Best regards, Elena
$166 USD in 7 days
5.0 (78 reviews)
5.8
5.8
User Avatar
Hey Barry or Daniel :) I think we can make this, I wrote several excel parsers in java and we can do whatever we want with it, create new tables, insert data, produce sql scripts or whatever. If you don't mind we can discuss that.
$147 USD in 3 days
4.9 (9 reviews)
5.1
5.1
User Avatar
Hi, I have more than 14 years of VBA/Excel/DB exp and I am expert in this kind of work. I have completed more than 250 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$200 USD in 20 days
4.9 (30 reviews)
5.0
5.0
User Avatar
A proposal has not yet been provided
$222 USD in 3 days
5.0 (4 reviews)
4.9
4.9
User Avatar
A proposal has not yet been provided
$305 USD in 3 days
5.0 (7 reviews)
4.7
4.7
User Avatar
i am sql dba and having more then 5 yrs of experience , I am sql expert certified by oracle corporation and having good skill task related to import and export using any file. I can do this task easily
$111 USD in 3 days
4.7 (36 reviews)
4.8
4.8
User Avatar
Hello, I have been working with a MNC based company since last ~ 5 years, as an IT BI DWH Professional. The project is a BI DWH project which covers 3 layers of BI (ETL, Data warehouse & Reporting) and helped me in nourishing my talent in all the technologies around these 3 layers. Below are some key areas of my skills: • Expert on SQL Server, Oracle and MS Access Databases • Expert in BO XI, Cognos and SQL Server Reporting Service (SSRS) • Expert in & designing & Implementation of end to end ETL Process using Informatica & SSIS Tools • Expert in Designing Qlikview Dashboard BI Solution • Expert in ER & Dimension Data modeling • Complete Command on PL/SQL concept e.g. Procedures, Functions, packages and complex queries. • Basic knowledge of Unix Shell scripting • Web Development using Java, CSS, and HTML ,PHP & Java Script • Expert in excel Macro • Expert in C & C ++ Programming I have experience in all the above areas and during my project work I have completed all of the above tasks. As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. I had conducted Informatica & DWH training for a US based training organization from Nov’14 to Dec’14. We recently started our own company “Point5Nyble Your Needs, Our Dream”. We always work to provide Best Delivery with 100 % customer satisfaction Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Point5Nyble Ashish Seth
$155 USD in 3 days
4.8 (32 reviews)
4.9
4.9
User Avatar
HI, I am a young enthusiastic IT Professional over 5 years of work experience in developing web based & desktop solutions as a software engineer. I have good command over Asp.Net, VB, C#, SQL Server, JQuery, JavaScript, Bootstrap, AngularJS, MVC, nopCommerce, Web Services, Window Services, AJAX, Json, Crystal Reports etc. I always try my level best to deliver quality work within given timelines. Moreover I have always emphasized on usability, compatibility, ease-to-use, optimization and compression of application for minimum access time so that I can facilitate up to low bandwidth users in an efficient manner with great ease. Below are details of some of my projects; 1) Solution For Indenting Traders 2) Online team collaboration, training, and knowledge sharing portal 3) Online IT Help Desk 4) Employees Training Management System (ETMS) 5) Employee Leave Alert System 6) E-Ticket Management (ETM) 7) Email Parser 8) FCE (Functional Capacity Evaluation) 9) EasySeatListing 10) EasySeat
$250 USD in 10 days
5.0 (1 review)
4.7
4.7
User Avatar
Hi, I am 12+ years experienced Database Programmer at CMMI-5 level company. I am Personally working on : RDBMS : Oracle,MySQL, MSSQL Server 7.0/2000/2008R2 and Onwards. Database Tools : Database Configuration Assistant, Database Migration Assistant,SQL/Oracle Trace, EXP/IMP, SQL*Loader, RMAN. Oracle Appex, forms, Reports. Let me know when can we discuss more.
$155 USD in 3 days
4.0 (28 reviews)
5.5
5.5
User Avatar
Hi, you can find my skills and references on linkedin (angnut) I have a lot of experiences in SQL and data manipulation activities. Please send me more details to have a feedback.
$244 USD in 4 days
5.0 (20 reviews)
4.2
4.2
User Avatar
La propuesta todavía no ha sido proveída
$155 USD in 14 days
5.0 (18 reviews)
4.1
4.1
User Avatar
Hello, I am a developer with more than 15 years of experience in database programming, full knowledge of transact-SQL and a lot of experience working with data en Excel files. If you are interested in my participation in the project please accept my bid and escrow the milestone. Kind Regards, Diego Fernando Prado Riestra
$140 USD in 7 days
5.0 (10 reviews)
3.8
3.8
User Avatar
Dear Sir, I'm expert with data migration / data manipulation. I have 8 years experiance with MSSQL. You will pay me only if you are 100% satisfied. Thank you ! Regards, Tomislav
$155 USD in 3 days
5.0 (5 reviews)
3.5
3.5
User Avatar
Hi. I am professional database developer. I can deliver you a requested task for SQL conversion. If you want to chat more, feel free to contact me. Thank you.
$111 USD in 5 days
5.0 (8 reviews)
3.3
3.3
User Avatar
Hello Sir/Madam I have solid experience as Oracle, SQL Server, Sybase, Access DBA. I am SQL server certified DBA in both as DBA and Designer. I worked as DBA in USA for 13 years. I came back recently to start my own work. I have a number of excellent reference as DBA, Architect and Modeler. Extensive experience in Data migration from flat file, excel file to Database. Please take a look at my resume and you will find that I am the best fit for this job. I have just completed couple of projects on database and the clients were from Australia, Canada, GB, USA and Russia. Currently I am working on a USA project Please see the review. Appreciate your kind attention in this regard, Warm regards,
$101 USD in 3 days
4.9 (9 reviews)
3.6
3.6

About the client

Flag of UNITED STATES
Jacksonville, United States
5.0
44
Member since Nov 15, 2014

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.