Excel to SQL import and export w/ data management interface



Willing to pay more for expedited quality delivery. Please let me know your estimated time needed.

This project will handle imports of excel files into a database repository that will also need to be built on MS SQL 2008 R2. It will allow the user to map the fields in the Excel file to available fields in the DB (the imported Excel files may have several different formats). Once the mapping is done for a file, this mapping should be saved in the application to select for future imports. This import will also allow the user to append metadata to the import; such as an expiration date or file source; these fields would be predefined via an area in the import section of the application.

They application will also handle exports to an Excel file that a user can select the criteria of the records to be exported. The application will store in a table the number of records that happened in the export and a hyperlink to the file. This functionality will do a concatenation of all the records in both the Master and Company repositories.

The user will also be able to use a % slider to do "De-duplication" on records in the database. Upon finding duplicates, the user will be able to select the record they want to retain, the other records will be moved to an archive (see below). This functionality will do a concatenation of all the records in both the Master and Company repositories.

The application will have a simple admin area where they can add users, and set the users permissions (Admin or User).

The Database will have 3 repositories, the Master Repository, the Company Repository, and the Archive. All records will sit in the Master repository unless they have been flagged to be moved. The Databases should use a star-schema.

The application have a section that will allow the user to select records to flag them to be moved to the Company Repository.

Skills: .NET, ASP, C# Programming, SQL, Website Design

See more: data import export interface, sql 2008, excel interface sql 2008, excel sql interface, where is w, repository.db, import ms project, formats in excel, finding net, excel to application, db import export, 5 and below, all star management, master excel, star w, sql import, sql duplicates, Sql 2012, Records management, r2, master data, import/export, import sql, Import Export, import excel

Project ID: #1615537

38 freelancers are bidding on average $6052 for this job


Hello ,we have gone through your project named Excel to SQL import and export w/ data management interface and we like to convey that we have already done similar kind of projects before also. We can address any conce More

$5000 USD in 40 days
(62 Reviews)

We have gone through your requirement and we do have 5 years of experience and assure you the product of your choice and will complete the work on time with excellent quality, please do check your inbox for more detail More

$5000 USD in 50 days
(103 Reviews)

Hi, We have excellent .Net,ASP.net,MVC,WCF,WPF,Silverlight,sharepoint and PHP expertise. Please have a look at private message for relevant work done. Awaiting a positive response from your end and looking forward More

$8000 USD in 90 days
(49 Reviews)

Hi there, We would love to talk with you about your project! I am sure you will be bombarded with very low bids & constant messages for your project, by providers promising the earth, but in reality providing low qu More

$8500 USD in 45 days
(5 Reviews)

We are interested, see your inbox.

$8400 USD in 45 days
(91 Reviews)

Hello Eric, Thank you for taking my call a while back and as suggested by you I am sharing my queries here with a brief about our company. The bid is certainly a placeholders bid and I will give a firm estimate once More

$13600 USD in 72 days
(6 Reviews)

I run European website design firm with years of design experience personally developing over 300+ websites. I can also provide a list of references from past customers if you'd like. I'm not the cheapest you'll find, More

$5777 USD in 35 days
(32 Reviews)

Pls cehck PM

$5000 USD in 50 days
(22 Reviews)

Kindly Check PMB

$5000 USD in 15 days
(16 Reviews)

I'm ready and interested to build the application Please Check PM

$5000 USD in 15 days
(1 Review)

We are a two man development team out of WI, USA. Please see PM.

$5000 USD in 40 days
(7 Reviews)

################### ******************* PLEASE CHECK THE PM **************** #############

$5000 USD in 40 days
(6 Reviews)

***** Dear. Please check your PMB. Best regards. Petter. *****

$5000 USD in 30 days
(1 Review)

Hi, Ready to start. Please Check PMB

$6000 USD in 30 days
(1 Review)

Hi, I have done similar project and working both excel and sql data exporting in custom format.

$8000 USD in 75 days
(0 Reviews)

The project will be completed within or before the specified time as per the requirements with the help of experienced and skilled work force using latest technology.

$5100 USD in 40 days
(0 Reviews)

Solid Experience working with SQL Server , .NET , Excel . I have been working on such application for dataware house department in my company for more than 3 years . I Developed such application However , the feature More

$5000 USD in 14 days
(0 Reviews)

Hi,I'm experienced programmer and system administrator (Yerevan State University master degree) and I can do this work with good quality. Contacts skype aramaram155 mobile +37498333397

$5000 USD in 9 days
(0 Reviews)

SQL MICROSOFT CERTIFIED PROFESSIONAL DEVELOPER (70-433 / 70-516 / 70-511 Exams) Six year in SQL development. I've see ppt documentation. I'm ready to start

$6000 USD in 20 days
(0 Reviews)

Have implemented a similar kind of functionality in my past wprk ex. Have recently joined the freelancer community, have an experience of 2 years in .NET and SQL in a reputed indian IT company. You can message me f More

$7500 USD in 45 days
(0 Reviews)