Hello,
I have around 400 CSV files (70 GB) and want to import them into my database.
The CSV files have more columns than I need. So is it possible to ignore some of the columns? I can change the order in the table structure, but can't find a setting to ignore colums.
It would be a big effort to edit each file and remove the columns I don't need. Or are there any programs for Windows to edit multiple CSV files automatically?