posted 13 years ago
MySQL has a convenient command for loading CSV data into a table. I would wrap that in a PowerShell script that gets the CSV files. So it would look something like this:
I haven't tried this exact code, so there might be some bugs to iron out. I did ensure that a mysql commandof the type in the above code will work on PowerShell, including the expansion of the $table and $csv variables.