'Automate data import from excel to SQL
i am working on a power Bi project, i need a lot of excel files to be uploaded regularly ( every 15 min) load the data into SQL tables ( truncate the data before the insertion > upload new data) ? how can i do it ? and is it even possible ?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|