In Progress

[url removed, login to view] Page to allow users to import spreadsheet files

Hello - I have one page on my [url removed, login to view] 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 [url removed, login to view] code. No work needed on the [url removed, login to view] / HTML markup. You will need to have SQL Server installed on your computer or server to work on this. I will supply all HTML, [url removed, login to view] 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, looking duplicate data excel, html spreadsheet code, html spreadsheet, get asp net, case net, box net, asp net need html, sql server scripts, import two, getuser, excel sort date, duplicate table, html gridview, net excel import, sort excel date, net spreadsheet, gridview database, net import excel, sql view table, allow upload, visual read files, net etc, visual basic scripts, html file net

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

Project ID: #1246904

Awarded to:

tuyenvt

Dear sir. I have experience do this job (http://www.freelancer.com/projects/1171098.html), 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