GetACoder.com

 
 

Home | My Account | Post Job | Browse Jobs | RSS Feeds | Careers New!

 

Convert Excel To SQL Using .Net

 
 
     
Job Summary:
 
Job Type: Project
Budget: $ 100-250
Required Skills: ASP .NET, SQL Server
Attached Files: Convert_spec.xls
 
Status: Work Performed (selected user Sandev)
 
Buyer Summary:
 
Username:
tershoes  
Feedback Score: 9.00/109.00/109.00/109.00/109.00/109.00/109.00/109.00/109.00/109.00/10 3 reviews
Award Reliability: 3 posted 3 paid
 
Location: London, United Kingdom
Member Since: March 7, 2010
 
Invited Users: There are no invited users


Description
Transfer Excel rows to multiple Tables in SQL2005 using asp.net (vb)

To be able to take an excel sheet and for each row INSERT or UPDATE multple tables depending upon the column.

There are only about 2200 rows of 200 columms and 5 tables updated but I'd like the automation to assure accuracy.
Only about 65 of the columns will be used to update any of the tables.

There are three data transformations used in a number of fields.
The first uses a Regular expression to replace all non standard alpahnumeric with "-", i.e. "/[^a-zA-Z0-9]/", "-"
The second one requires 0 tranforming to 1 and 1 transforming to 0
The third uses a fixed text string as a part of the Select of "TableF"

Processing will be to Read each row and :
For Columns relating to "TableS"
Check if the record exists, Update or insert the data

For Columns Relating to "TableR"
Check if the record exists, Update or insert the data
The ID generated by an insert or select will be used a a foreign key in "TableD" updates

For Columns Relating to "TableD"
Check if the record exists, Update or insert the data
The "TableR" ID created or found will be inserted into the "TableD" record
The ID generated by an select will be used a a foreign key in "TableL" updates

For Columns Relating to "TableL"
Check if the record exists, Update or insert the data
The "TableD" ID created or found will be inserted into the "TableL" record
The ID generated by an insert or select will be used a a foreign key in "TableA" updates

For Columns Relating to "TableA"
Check if the record exists, Update or insert the data
The "TableL" ID created or found will be inserted into the "TableA" record
The ID generated by an insert or select will be used a a foreign key in "TableF" updates

For Columns Relating to "TableF"
Check if the record exists, based on a combination of "TableA" ID and column name Update or insert the data
The "TableA" ID created or found will be inserted into the "TableF" record

If this is to be automated I will need a quick response and quick turnaround.

The attached sheet demonstrates the contents to be imported. It extends to Column:EL Row 3 indicates the type of data which may be encountered. Columns without headings will not be processed.

I have available the database schema and sample XLS to interested parties.


Additional information: Submitted on 03/07/2010 at 9:13 EST

Attachement Added




Reminder
You may not start working in this and any request before your bid is accepted. Users who violate this policy may have their accounts permanently suspended.



 Bids Received (3)   Shortlist (0)   Declined Bids (13)   
Average bid amount:   $113.33   Average delivery time:   2 Day(s)
Place Bid | Post Similar Job | Send Request | Contact tershoes

Order by:

 

Remember that contacting the other party outside the site (by email, phone, etc.) on all business jobs (before the request is awarded) is a violation of our terms of use. We supervise all site activity for such infringements and can immediately expel transgressors on the spot, so we thank you in advance for your cooperation. If you notice a violation please help out the site and report it. Thank you for your help.
 

 
send private message
Un-Decline Bid
Premium User  
software  
Ahmedabad, IN
location
US$190
bid amount

9.68/109.68/109.68/109.68/109.68/109.68/109.68/109.68/109.68/109.68/10
(72 reviews)

feedback
19 day(s)
delivery time

 
 
Decline Reason: Did not address my project requirements
We are specialized for web-design and development using HTML, XML, JavaScript, CSS, AJAX, ASP, PHP, ASP.Net C#.Net or VB.Net , with Ms-Access / MySQL / Ms-SQL -2007 / Oracle. Our design and multimedia expertise including Photoshop / Fireworks / CorelDrow / Dreamweaver and Flash 8.0 We are selective about the jobs we approach, taking into careful consideration the talent and expertise we have on hand to fulfill your goals.
Bid Time: 03-08-2010 09:36
 
send private message
Un-Decline Bid
Premium User  
Sumanta007  
kolkata, IN
location
US$150
bid amount

9.65/109.65/109.65/109.65/109.65/109.65/109.65/109.65/109.65/109.65/10
(54 reviews)

feedback
12 day(s)
delivery time

 
 
Decline Reason: Did not address my project requirements
Hello, I have done this type of work previously and can do it. I do not find any attached sheet. Please open chat session so that we can discuss and start the work. Thanks SM
Bid Time: 03-07-2010 08:57
 
send private message
Un-Decline Bid
Premium User  
rntsolutions  
Indore, IN
location
US$250
bid amount

9.57/109.57/109.57/109.57/109.57/109.57/109.57/109.57/109.57/109.57/10
(21 reviews)

feedback
6 day(s)
delivery time

 
 
Decline Reason: Bid is too high
Please open chat for further discussion...
Bid Time: 03-07-2010 12:58
 
send private message
Un-Decline Bid
Premium User  
anigh1982  
kolkata, IN
location
US$230
bid amount

8.73/108.73/108.73/108.73/108.73/108.73/108.73/108.73/108.73/108.73/10
(15 reviews)

feedback
25 day(s)
delivery time

 
 
Decline Reason: Did not address my project requirements
“SEARCHING FOR THE RIGHT MATCH” we’ve been working in web development industry since last 4 years. We are committed to deliver the highest level consulting and development services. Read your requirement and everything has been understood. We have already delivered a couple of similar projects and given our strong capabilities. I am confident we can deliver a powerful end-result to you as well. Our prime objective is client satisfaction and fulfills their needs with unlimited efforts. WE DO : * work personally with you ; during business hours through the communication means by your choice ; in simple English, to ensure a concise implementation of your satisfaction ; into 100 % W3C compliant and validate ( optional ) clean ; efficient web coding and design. WE DON’T : * talk sweetly and give assurance and give wrong commitments.
Bid Time: 03-07-2010 11:11
 
send private message
Un-Decline Bid
fahimkhanjadoon  
Abbottabad, PK
location
US$100
bid amount

8.86/108.86/108.86/108.86/108.86/108.86/108.86/108.86/108.86/108.86/10
(42 reviews)

feedback
3 day(s)
delivery time

 
 
Decline Reason: Did not address my project requirements
Sir:Can do it upto your utmost satisfaction.Waited to be interviewed by you via chat. thanx, Kind Regards.
Bid Time: 03-07-2010 13:49
 
send private message
Un-Decline Bid
agupta3304  
kolkata, IN
location
US$200
bid amount

9.79/109.79/109.79/109.79/109.79/109.79/109.79/109.79/109.79/109.79/10
(34 reviews)

feedback
10 day(s)
delivery time

 
 
Decline Reason: Reason not provided
yes i can do this.Please open the pm for details.
Bid Time: 03-08-2010 00:59
 
send private message
Un-Decline Bid
doublebitbd  
Dhaka, BD
location
US$250
bid amount

8.50/108.50/108.50/108.50/108.50/108.50/108.50/108.50/108.50/108.50/10
(24 reviews)

feedback
5 day(s)
delivery time

 
 
Decline Reason: Bid is too high
we are able to do this, pls open chat option for more details ....
Bid Time: 03-07-2010 13:32
 
send private message
Un-Decline Bid
Badal  
Dhaka, BD
location
US$130
bid amount

(No Feedback Yet)
feedback
7 day(s)
delivery time

 
 
Decline Reason: Did not address my project requirements
I have an IT firm. My team can handle any kind of job. We are very expert about free lancing job. Now in my team has near about 220 employees
Bid Time: 03-07-2010 13:17
 
send private message
Un-Decline Bid
Deepakacoder  
India, IN
location
US$200
bid amount

(No Feedback Yet)
feedback
25 day(s)
delivery time

 
 
Decline Reason: Service provider did not have necessary expertise
I have 7 Working Experince in DEsktop as well as Web Applications and WebServices. please give me Work Oppertunity. Thanks.
Bid Time: 03-07-2010 14:55
 
send private message
Un-Decline Bid
softcoder05  
Ahmedabad, IN
location
US$200
bid amount

(No Feedback Yet)
feedback
5 day(s)
delivery time

 
 
Decline Reason: Did not address my project requirements
Dear Buyer, We are the team of 15-20 People including developers and designers. Our team includes experienced persons in field of different technologies. Our Customer set belongs to Europe, USA , Australia and many other countries around the Glob. We are providing our services to many different and advanced technologies. Our work field includes CMS (Content Management System), Web Technologies, Application Software Development and Real-time Software development. We have more than 7 years of experience to work with Joomla, Drupal, Wordpress, Magento, VB.net, C#.net, ASP.net,JAVA, J2ME, JSP, VB, PHP, MySQL, MSSQL, C, C++. Visit our portfolios to know about my work and We are not a premium member of GetaCoder so can't add more then 5 portfolios. Please connect via chat for further discussion. Thanks Regards Softcoder05
Bid Time: 03-07-2010 22:01
 
send private message
Un-Decline Bid
superrasm  
CENTREVILLE, US
location
US$100
bid amount

(No Feedback Yet)
feedback
5 day(s)
delivery time

 
 
Decline Reason: Did not address my project requirements
We are .net certified professional. We are 5 years DBA exp at SQL Server 2005/2008. Please accept our bid or chat with us. We will provide 100% solution. you can pay us once we complete our work.
Bid Time: 03-08-2010 07:00
 
send private message
Un-Decline Bid
nobinjose  
Singapore, SG
location
US$200
bid amount

(No Feedback Yet)
feedback
4 day(s)
delivery time

 
 
Decline Reason: Bid is too high
Hi There, I have reviewed the requirements. Confidently offer willingness to finish this easily. Thank You
Bid Time: 03-08-2010 10:01
 
send private message
Un-Decline Bid
nirmalS  
jaipur, IN
location
US$140
bid amount

(No Feedback Yet)
feedback
8 day(s)
delivery time

 
 
Decline Reason: Did not address my project requirements
i can help u to complete it
Bid Time: 03-08-2010 10:14
 
 


 
Get the Free Step-by-Step Guide on How to Use GetACoder
The act of outsourcing jobs has become easy in the past few years thanks to GetACoder. However, our team aims at making the whole process even easier. So, it has now come the time to provide you with a step-by-step guidance on how to use this service and succeed in the outsourcing world totally for FREE.

It doesn't matter if you are a more experienced user or a novice; using GetACoder will become even simpler with the help of this E-book. There are two major sections: a Buyers section and a Coders section.

Buyers will learn:
  • How to outsource safely
  • How to pick the best freelancers
  • How to manage time and money

Coders will learn:

  • How to get the best jobs
  • How to secure their payments
  • How to build a long-lasting relationship with buyers

    ...and MUCH MORE
Clear examples and pictures illustrating key situations, great tips and real testimonies of some of our best users... all in this Outsourcing Guide.  So don't loose the outstanding opportunity to download GetACoder FREE E-book.
The Outsourcing Revolution: Why It Makes Sense and How to Do It Right
The Outsourcing Revolution: Why It Makes Sense and How to Do It Right
What is GetACoder?

GetACoder.comGetACoder is a leading Global Services Marketplace doing business in more than 200 countries. Our unique system accelerates your time to market and provides your business with key competitive advantages. When you use GetACoder you are stretching your budget and saving as much as 60% over traditional outsourcing. GetACoder is changing business, now it's no longer about what you own or build but which resources and talent you can access. With GetACoder you reduce expenses, increase efficiencies, aggressively grow your business, and create a sustainable competitive advantage. GetACoder makes outsourcing to any part of the world an easy task! With GetACoder it's simple to outsource any business request, gain access to global talent and manage jobs online.

One of the main advantages of GetACoder is the low labor cost. The typically rates are about seven times lower than the ones in the US or Europe. Posting a request at GetACoder allows the right professional or company to find you and to bid for your work. We are building a reputation for exceeding our customers' expectations and for becoming an extremely cost effective way to outsource work. Use GetACoder when you want to save money, increase efficiency or accelerate the development of your request. With GetACoder you focus on growing your business and let others do the tedious work. Post your request on GetACoder for free. Find out why people outsource jobs with us day after day.

Thousands of Satisfied Customers - Submit/View Quotes


-No matter what the project, GetACoder has always pulled through. There really are some great designers providing quality work at competitive prices here. This truly is my one stop shop - sapper6fd
-I love to bid on GetACoder, its a good site for posting projects as well as getting income for me. Thanks GAC - johnyb
-I greet GetACoder because it's a great website. - thanayuth852
Report Violation    Privacy Policy     Affiliate Program    Terms of Use    Contact Us    Help      GetACoder.com on Facebook      Follow GetACoder on Twitter      GetACoder.com Latest Requests RSS Feed
© 2004-2012 GetACoder. All rights reserved.