Application that can upload excel sheet to sql table

Durum: Closed
Ödül: $85
Alınan Girdiler: 18
Kazanan: mgliviu

Winner

Yarışma Özeti

I need an application where:

1) I can select an excel file (xlsx) from my computer
2) The file contains data about customers and what they bought, but each row is a order. This means each customer can be on the list multiple times if he bought more than one product. The application needs to reorganize data so a customer is only one row, but products are added as new columns. There is a max of 10 product columns
3) The application must insert the data in the new format to a MS SQL database

I will provide a sample file with instructions and access to sql server

The application has to be a windows application - NOT website/webapp

You can choose the dev language you want.

I expect this task to be easy and be less than 4 hours work for a good developer

Aranan Beceriler

Winner

Benzer Yarışma İlan Et

İşveren Geribildirimi

“Fast and competent guy! Would absolutely hire again”

Clevercow, Denmark.

Genel Açıklama Panosu

samtoulayl
- 9 yıl önce
Please check #22 , in case you're looking for more flexible solution.
- 9 yıl önce
sam7181
- 9 yıl önce
I have done this. In addition I can make a mobile version for this as well so that you can do it on the go from anywhere.
- 9 yıl önce
marasinghe82
- 9 yıl önce
Dear Sir,

We can do excel upload using ASP.net custom code, SSIS solution or SQL script please send the sample excel sheet with data. I’ll do it now

Nest Regards,
Jinesh
- 9 yıl önce
Gongzhiq
- 9 yıl önce
please send sample excel file
- 9 yıl önce
lucasroy7
- 9 yıl önce
I already have a SSIS package that imports Excel files. I only have to configure it for your needs.
- 9 yıl önce
bouslimi1979
- 9 yıl önce
Please check my proposal. I will code a VBA macro for this. Thanks
- 9 yıl önce
BMHONEY
- 9 yıl önce
I can do this using SSIS and DTS services. We can discuss about this more.
- 9 yıl önce
SunilGowda81
- 9 yıl önce
I can Implement this. you can contact me.
- 9 yıl önce
vladang
- 9 yıl önce
I can do this job. We can discuss more...
- 9 yıl önce
ygiuhu
- 9 yıl önce
I have experience on it, please contact to me to discuss. Thanks.
- 9 yıl önce
nikhilkewat
- 9 yıl önce
Is it in predefined format or its totally dynamic..
- 9 yıl önce
nikhilkewat
- 9 yıl önce
Please discuss this in detail .What type of excel sheet would be there .
- 9 yıl önce
cheapexcell
- 9 yıl önce
Please contact me to discuss
- 9 yıl önce
chetanraj81lx
- 9 yıl önce
Please discuss with me for this work Thanks
- 9 yıl önce
Navneet066
- 9 yıl önce
i will do it today itself
- 9 yıl önce
Gongzhiq
- 9 yıl önce
hi, i can do what you want asap.
- 9 yıl önce
Navneet066
- 9 yıl önce
I can do it.
- 9 yıl önce
jangkoo
- 9 yıl önce
I can do this quick
- 9 yıl önce