CSV To MYSQL and SQL Example script

Cancelled

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.

thanks

Skills: MySQL, SQL

See more: example mysql script, csv mysql, mysql documentation, sql mysql, mysql to sql, mysql backup, mysql and sql, move sql, example, backup sql mysql, sql create script, sql backup mysql, script schedule, import files folder, import sql database mysql, vbs windows, example visual basic, visual basic 2013, Create sql database, mysql batch, sql file csv, script import mysql file, import csv database, csv import sql database, import mysql csv

Project ID: #4635237

11 freelancers are bidding on average $161 for this job

eperfections

Hi, I have worked with you on a similar project before. I can do this project as well. Please award me.

$105 AUD in 2 days
(125 Reviews)
6.5
truongngocthanh

Hello, I can do it right now, Please check your PM for more detail. Thank you

$166 AUD in 3 days
(17 Reviews)
4.8
abhius

Hello Sir, Dedicated and professional committed to deadlines. Ready to start. Pls check message for details. Thanks.

$252 AUD in 5 days
(18 Reviews)
4.7
JoomlaVogue

Hello Sir, We have gone through the details you have provided and would be pleased to work on this with you to deliver the results that you have expected and We are sure you will not be disappointed if you give us More

$144 AUD in 3 days
(4 Reviews)
4.2
skysap

I can start this job right now. I read your job description very carefully. Please check PMB

$412 AUD in 7 days
(5 Reviews)
4.0
developer287

i am expert vb.net programmer. i can write this script in vb.net it will be the best. please see private message.

$70 AUD in 3 days
(11 Reviews)
3.8
gressp

will get the job done and fast

$30 AUD in 3 days
(4 Reviews)
2.5
aoefmpes

pl check your inbox

$222 AUD in 7 days
(3 Reviews)
2.3
ashishpahlaz

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.

$111 AUD in 3 days
(0 Reviews)
0.0
techzer

I'm in Melbourne, ready to meet you and start working.

$200 AUD in 2 days
(0 Reviews)
0.0
thanhhungqb

Dear sir, I am interested in your project, I can finish it on 3 days. Hope you choose me do it for you. Thank you very much.

$54 AUD in 3 days
(0 Reviews)
0.0