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.
11 freelancers are bidding on average $161 for this job
Hi I am a mysql developer for past 2 years, and have also written a few batch files in windows. I can do this in 3 days. Kindly give this opportunity to me.