Associate
Hi,
Is there a way to bulk load a list of csv files into a MySQL database where a new table is created from the import of the 1st file and then all the remaining csv files are appended to this table.
The files are named:
2011-01-07.csv
2011-01-14.csv
2011-01-21.csv
2011-01-28.csv.....
up to the end of 2011, ie, 52 files.
The files are quite large, each csv file is approx 275mb.
I can create a macro in microsoft access to do it but the problem is that an access database mdb file cannot exceed 2gb and this is exceeded quite quickly. I know that MySQL will not have the same file size constraint but I am not familiar with how to bulk load or create a macro in MySQL to do the job.
Binty
Is there a way to bulk load a list of csv files into a MySQL database where a new table is created from the import of the 1st file and then all the remaining csv files are appended to this table.
The files are named:
2011-01-07.csv
2011-01-14.csv
2011-01-21.csv
2011-01-28.csv.....
up to the end of 2011, ie, 52 files.
The files are quite large, each csv file is approx 275mb.
I can create a macro in microsoft access to do it but the problem is that an access database mdb file cannot exceed 2gb and this is exceeded quite quickly. I know that MySQL will not have the same file size constraint but I am not familiar with how to bulk load or create a macro in MySQL to do the job.
Binty