176985602337900

Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

Program or batch file that will convert a flat text file into a SQL query
Sign in to Add to Watch List

IT & Programming > Other IT & Programming

View Change History

The client has made the following changes to the job.

Description
Date

Job awarded.

Jan 17, 2013
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Wed, Jan 16, 2013
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:
    Anywhere

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Budget: Less than $500
  • Fixed Price Job
  • Elance Escrow Protection
  • W9 Not Required
Sign in to view client's details

I need some sort of program or batch file written that will convert a flat text file into a SQL query. The program will need to run on my Windows PC. The text file looks like this:

AAM0180C 7
AAM0181 32
AAM0201C 6
AAM0202 24
AAM0203C 9
AAM0204 12

and I need the SQL query to then look like this:

update products set products_quantity=7 where products_model='AAM0180C';
update products set products_quantity=32 where products_model='AAM0181';
update products set products_quantity=6 where products_model='AAM0201C';
update products set products_quantity=24 where products_model='AAM0202';
update products set products_quantity=9 where products_model='AAM0203C';
update products set products_quantity=12 where products_model='AAM0204';

Sign in or Register to see more

Desired Skills
PHP, DOS, SQL
Job ID: 36908931
Proposals
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 United Kingdom
Professional IT Engineer looking to expand into freelance work.
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 36915811  |  Submitted: Jan 16, 2013 14:44 ET 
Proposal SEALED

 Pakistan  |  
Experienced PHP, ASP.Net developer, expertise both in desktop and web application. Expert in database driven application with excellent user...
7
  |  
 4.7   |  Private   |  77 Jobs   |  1 verified credential(s)
Bid ID: 36915601  |  Submitted: Jan 16, 2013 14:38 ET 
Proposal SEALED

Dilip Kumar S.      
Dilip Kumar S.'s identity has been verified.  Learn More
 India
We create Websites, Web Applications, Mobile Web Applications, Ad Serving, Mobile Websites with Stripe Payments Integration. A highly energetic and...
3
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 36913667  |  Submitted: Jan 16, 2013 13:28 ET 
Proposal SEALED

 India  |  
My portfolio has details about my previous works. https://www.elance.com/s/aegansys/portfolio/ Reliable Windows developer (C/C++/C#) with 5 year...
Skills: C, C#, C++
4
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 36913302  |  Submitted: Jan 16, 2013 13:16 ET 
Proposal SEALED

 Ukraine  |  
More than 10 years in software development. Self-motivated and solution oriented professional with broad experience in working with teams across...
2
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 36912303  |  Submitted: Jan 16, 2013 12:47 ET 
Proposal SEALED

 India  |  
My name is Sunil, and I manage a very experienced and well-seasoned team of software engineers. I am excited to have a team with such a great skill...
3
  |  
 4.9   |  $1,299 Earnings   |  5 Jobs
Bid ID: 36911413  |  Submitted: Jan 16, 2013 12:19 ET 
Proposal SEALED

 Ukraine  |  
I am a professional developer with more than 10 years of experience in web technologies and desktop development. I have a long track record of...
1
  |  
 5.0   |  Private   |  39 Jobs
Bid ID: 36910906  |  Submitted: Jan 16, 2013 12:03 ET 
Proposal SEALED

Chaminda Thilakarathna      
Chaminda Thilakarathna's identity has been verified.  Learn More
 Sri Lanka
More than 10 years of experience gain high quality output. Ready to take challenges of difficult programming tasks. code from begin to end. No...
2
  |  
 0.0   |  Private   |  2 Jobs
Bid ID: 36910885  |  Submitted: Jan 16, 2013 12:03 ET 
Proposal SEALED

Andrew Phillips      
Andrew Phillips's identity has been verified.  Learn More
 United Kingdom  |  
Winner
I am a PHP developer based in Cambridge, UK with over 8 years' experience. I specialise in high performance websites and server side optimisation...
3
  |  
 0.0   |  Private   |  0 Jobs   |  2 verified credential(s)
Bid ID: 36910565  |  Submitted: Jan 16, 2013 11:52 ET 
Delivery
Within 1 day
$20.00

 Russia  |  
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 36910498  |  Submitted: Jan 16, 2013 11:51 ET 
Proposal SEALED

 Egypt  |  
An experienced programmer for more than 10 years.
9
  |  
 4.8   |  Private   |  40 Jobs   |  2 verified credential(s)
Bid ID: 36910233  |  Submitted: Jan 16, 2013 11:43 ET 
Proposal SEALED

Jatin M.      
Jatin M.'s identity has been verified.  Learn More
 India  |  
Having 5+ years of experience in a PHP, MySQL, Javascript, Jquery, Prototype, Wordpress, Joomla, Web Services, Data Scraping, CodeIgniter, Kohana,...
4
  |  
 5.0   |  Private   |  1 Jobs
Bid ID: 36910205  |  Submitted: Jan 16, 2013 11:42 ET 
Proposal SEALED

Pradip N.      
Pradip N.'s identity has been verified.  Learn More
 India  |  
EXCEL, Data Extraction, SQL, Data Entry, ETL, Admin Work, Virtual Assistance, Database Handling, HTML, Photoshop
6
  |  
 4.6   |  Private   |  25 Jobs
Bid ID: 36910118  |  Submitted: Jan 16, 2013 11:39 ET 
Proposal SEALED
Sign in to Elance and start working on jobs today.
Sign in to view more of the job details and submit a proposal. Once registered, you'll have access to thousands of jobs online or through email.
Are you ready to post a job like this one?
Post a Similar Job »