Completed

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, asp.net 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:

tuyenvt

Dear sir. I have experience do this job ([url removed, login to view]), I can do it. Thanks

$30 USD in 3 days
(9 Reviews)
4.3

32 freelancers are bidding on average $53 for this job

shuvrapintu

Hi, Let start now. Please check PMB

$60 USD in 1 day
(81 Reviews)
6.4
tamrakar81

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)
5.5
snsTechnologies

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

$50 USD in 1 day
(19 Reviews)
5.4
subhanisaleem

hi plz check pmb

$60 USD in 2 days
(6 Reviews)
5.1
RainbowTechs

Ready to start work. Kindly check your PMB.

$55 USD in 1 day
(9 Reviews)
5.0
manhpham

I can do it quickly. Contact me ASAP.

$50 USD in 0 days
(31 Reviews)
4.8
yehia111111

Hi,Kindly check your PMB

$65 USD in 1 day
(5 Reviews)
3.7
CyberFsoft

I have finished some project like this.

$50 USD in 0 days
(3 Reviews)
2.4
innovadevelopers

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 Freelancer.com.

$50 USD in 1 day
(1 Review)
2.0
ishan1988

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)
1.0
sanjaykk

I have more than 6+ years of experience in working with data extract, transformation and upload using ASP.net. 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)
0.0
IForce187

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)
0.0
AhmedEj

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

$50 USD in 1 day
(0 Reviews)
1.3
naga009

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)
0.0
Mkar

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)
0.0
AmitNigam29

ya i can do easily

$60 USD in 10 days
(0 Reviews)
0.0
mike20098

I have working experience of same and will do easily

$38 USD in 4 days
(0 Reviews)
0.0
leeshleesh

i am new to freelancer

$70 USD in 15 days
(0 Reviews)
0.0
nettechdev

We can done.

$40 USD in 2 days
(0 Reviews)
0.0
AAtick

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