CSV To MYSQL and SQL Example script

  • Status Closed
  • Budget $30 - $250 AUD
  • Total Bids 7

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.


Get free quotes for a project like this
Awarded to:
Skills Required

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