Đã hoàn thành

SQL data conversion - Excel to SQL Server

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).

Kĩ năng: Khai thác dữ liệu, Xử lí dữ liệu, Microsoft SQL Server, SQL

Xem nhiều hơn: sql data conversion, route manager, learn sql, data conversion sql, cust write, word excel conversion data entry project, excel sync data sql, pdf excel conversion data entry, enter data sql server express excel, data primavera sql server excel vba, loading data sql server excel, export data sql server 200 excel 2007, excel modify data sql, write code transfer data sql server excel

Về Bên Thuê:
( 44 nhận xét ) Jacksonville, United States

ID dự án: #8319352

Được trao cho:

desconit

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 Thêm

$177 USD trong 3 ngày
(14 Đánh Giá)
4.4

45 freelancer đang chào giá trung bình $170 cho công việc này

jaylancer43

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 bidd Thêm

$210 USD trong 7 ngày
(261 Nhận xét)
7.5
truongnguyen86

Hello there, i'm expert on SQL Server, i've done many projects related to SQL skills, restore backup, data conversion between inside SQL Server and outside, tranform script procedure... Pls share me your bak file also Thêm

$250 USD trong 5 ngày
(140 Nhận xét)
6.5
fhasanbd

A proposal has not yet been provided

$250 USD trong 5 ngày
(106 Nhận xét)
6.7
hwanghendra

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 trong 3 ngày
(120 Nhận xét)
6.6
flashsaiful

Hello Dear, I can do this for you. Please send a massage in the PMB for details.......Best Regards flashsaiful

$155 USD trong 3 ngày
(98 Nhận xét)
6.3
siberiangirl

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 trong 7 ngày
(78 Nhận xét)
5.7
marasinghe82

A proposal has not yet been provided

$111 USD trong 3 ngày
(69 Nhận xét)
5.7
islamianwar

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 w Thêm

$147 USD trong 3 ngày
(9 Nhận xét)
5.1
appleofficer

A proposal has not yet been provided

$305 USD trong 3 ngày
(7 Nhận xét)
4.7
youthpassion

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 Thêm

$250 USD trong 10 ngày
(1 Nhận xét)
4.9
dpune

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. Thêm

$200 USD trong 20 ngày
(30 Nhận xét)
5.0
dogradiwakar

A proposal has not yet been provided

$222 USD trong 3 ngày
(4 Nhận xét)
4.6
AliSafder

It is routine work for me. Let me get it done very quickly for you. I have over 8 years of experience in Databases like Sql Server, Oracle, Microsoft Access and MySQL, Programming languages like MVC, .Net t Thêm

$120 USD trong 5 ngày
(24 Nhận xét)
4.5
angnut

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 trong 4 ngày
(20 Nhận xét)
4.2
vinaysinghh

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 trong 3 ngày
(28 Nhận xét)
4.6
point5nyble

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 Thêm

$155 USD trong 3 ngày
(28 Nhận xét)
4.8
acronymsolutions

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 Assis Thêm

$155 USD trong 3 ngày
(28 Nhận xét)
5.4
pablotorres

La propuesta todavía no ha sido proveída

$155 USD trong 14 ngày
(18 Nhận xét)
4.1
janmsidh

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 Thêm

$101 USD trong 3 ngày
(9 Nhận xét)
3.7
diegofpr

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 participa Thêm

$140 USD trong 7 ngày
(6 Nhận xét)
3.8