Hi,
im trying to conect to a SQL Database which can be done easily by "Get External Data" however what i want is the following:
-Read Data from SQL Server
-Able to modify the table that excel creates
-After modifications update that table to the Database in SQL.
i dont have a lot of knowledge so a HOW-TO guide is highly appreciated it!.
Thank you for looking at this post!
im trying to conect to a SQL Database which can be done easily by "Get External Data" however what i want is the following:
-Read Data from SQL Server
-Able to modify the table that excel creates
-After modifications update that table to the Database in SQL.
i dont have a lot of knowledge so a HOW-TO guide is highly appreciated it!.
Thank you for looking at this post!