CSV To MYSQL and SQL Example script

This project was awarded to developer287 for $70 AUD.

Get free quotes for a project like this
Employer working
Awarded to:
Skills Required
Project Budget
$30 - $250 AUD
Total Bids
Project Description

I am after two example script's developed for

1. Importing multiple csv files into Mysql and SQL. For example, if i have a directory called c:\import\ then all *.csv files drooped into this directory must import into the mysql and sql.
2. I must be able to customize the script's for new fields, databases and folder locations. Therefore will require documentation on how to do this.
3. I would like documentation on how to schedule these automatically in windows to check the directory and import in any new files
4. The script must move imported files into a backup directory

The script does not need to create the database tables, only import into existing structures.

I am after the script in either visual basic script format (*.vbs) or windows batch file. (must be able to schedule in windows)

I have attached a sample csv file.


Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online