CSV To MYSQL and SQL Example script
- Status Closed
- Budget $30 - $250 AUD
- Total Bids 7
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.
thanksGet free quotes for a project like this
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
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online