'How to upload multiple csv files to a SQL server Database using R
I have a folder with over 50 different csv files in my computer, with different names, different number of variables. I have to upload them to a SQL server and instead of having to upload them one by one I would like to ask how to batch upload them all at once while keeping their original names. I've tried creating a list csv <- dir(pattern = "csv") and then using RIO::export_list function but haven't figured out how to use it with DBI::dbWriteTable. I would be very grateful if someone has dealt with this in the past could help me.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|