ASP.Net Page to allow users to import spreadsheet files

Hello - I have one page on my ASP.Net website that needs to be completed. So far, I have buttons that allow users to upload and then view (in an ASP Gridview) an uploaded Excel spreadsheet. These buttons work ok. However, I am not able to get the actual import of the spreadsheet file into a SQL Server 2008 database to work correctly, . That's where you come in. This is not a simple import, however - it's pretty complicated - please don't bid until you have read all the requirements and have coded this sort of thing before. Here are the details:

* User must be able to import an Excel (or other type of spreadsheet) into a SQL database after upload.

* The import will take place into a SQL table with 11 columns. There is an Identity / Primary key column, several NULL and NOT NULL columns, and there are several different data types (date/time, smallmoney, varchar, etc.) on the table. Some of the NOT NULL columns require default values.

* Data for one of the columns will come from a drop down box.

* Data for another of the columns will be the currently logged in user ID that is uploading the file. Probably a [url removed, login to view] (?) I don't know, that's why I need an importing expert.

* Data for a third column will require duplicate checking of the column (easier to explain when you see the code I have so far).

* I will also need a way for the file to be renamed after upload, in case two or more users are importing data at the same time.

I have some of the code completed, but it's not working. It's VB.Net code. No work needed on the ASP.Net / HTML markup. You will need to have SQL Server installed on your computer or server to work on this. I will supply all HTML, VB.Net code (that I have so far), and SQL scripts for the tables and SQL statements. Thank you for looking.

Skills: .NET, ASP, Excel, SQL, Visual Basic

See more: sql get date, spreadsheet in html, looking for duplicate data in excel, html spreadsheet code, html spreadsheet, get asp net, case-net, case net, box net, asp net need html, where to work at 15, website, ASP.NET database, visual identity, sql server scripts, require net c#, import two, getuser, excel with sql server, excel to my sql, excel sort date, duplicate table, html gridview, net excel import, sort excel date

About the Employer:
( 23 reviews ) Riverside, United States

Project ID: #1246904

Awarded to:


Dear sir. I have experience do this job (, I can do it. Thanks

$30 USD in 3 days
(9 Reviews)

32 freelancers are bidding on average $53 for this job


Hi, Let start now. Please check PMB

$60 USD in 1 day
(81 Reviews)

Hi, I have gone through your requirement and I am glad that We already have it , Please give us opportunity to work with you. Thanks, TTS Team

$60 USD in 1 day
(52 Reviews)

That's an easy job, please see PMB for work experience details. Thanks!

$50 USD in 1 day
(19 Reviews)

hi plz check pmb

$60 USD in 2 days
(6 Reviews)

Ready to start work. Kindly check your PMB.

$55 USD in 1 day
(9 Reviews)

I can do it quickly. Contact me ASAP.

$50 USD in 0 days
(31 Reviews)

Hi,Kindly check your PMB

$65 USD in 1 day
(5 Reviews)

I have finished some project like this.

$50 USD in 0 days
(3 Reviews)

We have experience in migrations as you need. It would be nice to have an opportunity to collaborate with your project and begin work on

$50 USD in 1 day
(1 Review)

I have excellent exposure in SQL Server and .NET windows/web application. I can do this job for you on time with quality and hope that i would make you feel good,the way my earlier clients were with 100 % completion ra More

$40 USD in 2 days
(2 Reviews)

I have more than 6+ years of experience in working with data extract, transformation and upload using I can promise a quality delivery within timeline and providing excellent value for money. I hope to collabo More

$50 USD in 2 days
(0 Reviews)

Hello, Hope you are doing well. we have expertise in .Net technology. We have worked on many web and windows application. I have work experience of such excel import and save it to database for e-Commerce s More

$75 USD in 10 days
(0 Reviews)

hello, I am desktop and web developer and i can do this for you. please contact me. Thanks Ahmed Ejaz

$50 USD in 1 day
(0 Reviews)

I have 4 years of experience in ASP.NET web applications. I worked on similar requirement in the past.

$60 USD in 2 days
(0 Reviews)

Hello,This is very simple. we can take any spread sheet it may be excel 2007 or 2003. we will check duplicate value. and also we will not allowed any other format. i was working this type in my helth care merck projec More

$34 USD in 7 days
(0 Reviews)

ya i can do easily

$60 USD in 10 days
(0 Reviews)

I have working experience of same and will do easily

$38 USD in 4 days
(0 Reviews)

i am new to freelancer

$70 USD in 15 days
(0 Reviews)

We can done.

$40 USD in 2 days
(0 Reviews)

Hi I have 12 years working exp in .net. I think its a simple job. Please send me the codes

$44 USD in 5 days
(0 Reviews)