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. Work both in core and framework
8
  |  
 4.7   |  Private   |  88 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
  |  
 5.0   |  Private   |  1 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
  |  
 5.0   |  Private   |  2 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...
4
  |  
 5.0   |  Private   |  4 Jobs
Bid ID: 36911413  |  Submitted: Jan 16, 2013 12:19 ET 
Proposal SEALED

 Ukraine  |  
I am a professional developer with extensive experience in web technologies and Windows development. During my career I designed simple websites...
8
  |  
 5.0   |  Private   |  50 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 gives you a great job for very reasonable price. Ready to take challenges on time frame and difficulty. Provide...
4
  |  
 5.0   |  Private   |  4 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...
5
  |  
 5.0   |  Private   |  1 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.
7
  |  
 4.8   |  Private   |  75 Jobs
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,...
5
  |  
 4.8   |  Private   |  30 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
3
  |  
 4.5   |  Private   |  51 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 »