Import from excel spreadsheet to SQL table

Completed Posted Nov 21, 2012 Paid on delivery
Completed Paid on delivery

I need an ASP.NET project (source and all non-standard references/dlls etc to be able to compile) to perform the following tasks:

1) Have a file import button/field: This will take an excel spreadsheet (.xlsb format) and copy it to the server

2) Import each row from the spreadsheet into a MS-SQL Server table with the same name, using .NET and [login to view URL] to read from the spreadsheet.

3) Have error trapping with user-friendly error messages for points of failure.

4) A message upon successful completion of the import.

Additional deliverable:

5) SQL create-table script and any stored procedures you write for the process (though in-line sql in code is fine, too)

This is a function that will be performed 8 or 10 times a day by a non-technical person, so it needs to be simple and user friendly.

Visual Studio 2010, Framework 4.0 preferred. Earlier versions can be used and I can convert here, but VS 2010 is preferred.

MS-SQL Server 2008 is our database back-end, but the SQL for INSERTS and the like is fairly generic and so the version you develop on shouldn't really matter.

It doesn't matter if you use C# or VB.NET.

After testing and acceptance, I will be converting the application to work with our master-client page setup here, so minimal design elements are preferred.

I know the task can be done with fancy ajax/web-service based progress bars and the like. I also know it can be done very simply. I prefer simple.

A sample spreadsheet and description of fields will be provided, as well as information on primary keys, etc. Please design a database schema that will accommodate those fields.

Please provide working, bug free code. Due to security concerns and NDA agreements we have with clients, you will not be able to log into, work at, or test on our servers, so please have the capacity to work and test off-site at your location.

Editing project to add an example spreadsheet with two rows of data. Spreadsheet normally contains around 10K rows of data.

I have scrubbed the data to remove identifying customer information.

.NET Data Processing Excel SQL

Project ID: #2792145

About the project

77 proposals Remote project Active Nov 26, 2012

Awarded to:

shuvrapintu

Hi, I am interested to work for you. I have some queries . Please check your message box.

$300 USD in 5 days
(69 Reviews)
6.3

77 freelancers are bidding on average $324 for this job

developer0106

Hi, I can do it for you. Please check PM for more details. Thank you.

$250 USD in 5 days
(114 Reviews)
8.0
salmanaim

This seems a straight forward work, considering the requirements. Please check PM for work samples.

$300 USD in 7 days
(113 Reviews)
8.0
MMaghawry

It is easy task as I'm professional in Asp.net so please let me do it.

$300 USD in 7 days
(164 Reviews)
7.0
AnisInfoTech

Hello, We already have such module ready , import data from excel to mssql with .net. Actually we have 2 versions , one is simple import with fixed fields from excel to fixed field in database. Second is provi More

$350 USD in 4 days
(64 Reviews)
7.3
feninsoftech

Hi, This can be achieved by first creating CSV from EXCEL and then bulk insert data in SQL Server using a Stored Procedure. I have 7 years experience in C# and SQL Server

$300 USD in 20 days
(57 Reviews)
6.8
gkalish

Having 10 + years experience in .Net and Sql server and willing to do the work

$250 USD in 3 days
(139 Reviews)
6.5
sandeep25101982

Hi, C#/VB,SQL Excel Add-in expertise. Please see PM. Thanks

$500 USD in 10 days
(39 Reviews)
6.6
manhpham

Hi sir. Please let's me help you on this project.

$400 USD in 5 days
(68 Reviews)
5.8
triceraptordino

We are interested by this project.

$250 USD in 6 days
(33 Reviews)
6.0
marasinghe82

Dear Sir, if you ok to go with .xls or .xlsx i can give application with in one hour I need only 100$ Best Regard Jinesh

$250 USD in 1 day
(71 Reviews)
5.7
pabloresnizky

Hi, my name is Pablo, and I'm a .NET developer from Buenos Aires, Argentina. I looked at your project requirement and I'm very interested in it. I have more than 12 years in development with Microsoft technologies, More

$350 USD in 3 days
(3 Reviews)
5.4
subhanisaleem

plz check pmb

$300 USD in 5 days
(5 Reviews)
5.1
EProfSolutions

Detail in PM.

$250 USD in 5 days
(21 Reviews)
5.3
AliSafder

Hi, It is my routine work to create import / export wizards. Raring to go!!!

$250 USD in 3 days
(33 Reviews)
4.9
PChell

Here is .NET expert. Please check PMB.

$500 USD in 5 days
(18 Reviews)
4.9
ashutosh9910

Hi, i have been doing this regularly for a few of my clients. I can create a script for you that would serve your purpose. Please let me know if you would be interested. Thanks Ashutosh

$255 USD in 3 days
(34 Reviews)
5.2
sharpcodernet

Hi, .NET developer with 10+ years of experience is ready to help you. Please, check PMB for more details. Thanks.

$350 USD in 5 days
(25 Reviews)
4.8
itsEMinds

Hi Gregorylmahan, Have a great day. As I see, you are looking for a simple application which can import an spreadsheet(.xlsb) to SQL table. I've expertise and prior experience on it. And assure you to provide you More

$250 USD in 10 days
(14 Reviews)
4.8
bizbeesTeck

Hi, Please check private message for more details. Thanks, Jonathan

$250 USD in 12 days
(14 Reviews)
4.1
proegler

I retired in 2002 after 25-years developing database appplications for a range of clients. I had a decent run on Elance doing similar things and then got into a long term engagement with a client in the Netherlands do More

$270 USD in 5 days
(3 Reviews)
4.2