atuljadhavnetafim
Active Member
- Joined
- Apr 7, 2012
- Messages
- 341
- Office Version
- 365
- Platform
- Windows
Hi,
i have MS SQL table and also have one Powe query excel file on the desktop.
and that power query table link with 3 TXT files which import in power query and transform some data and combine all three file in one file.
now I want to upload this file to the SQL server table which has the same column name and sheet/table name,
I can also use Management studio to upload this file but if power query directly uploads this file to MS SQL table and replace existing data.
is there any way?
i have MS SQL table and also have one Powe query excel file on the desktop.
and that power query table link with 3 TXT files which import in power query and transform some data and combine all three file in one file.
now I want to upload this file to the SQL server table which has the same column name and sheet/table name,
I can also use Management studio to upload this file but if power query directly uploads this file to MS SQL table and replace existing data.
is there any way?