Update SQL Server database data into same Excel sheet and column

[Saxon10]

Hi,

I would like to get the SQL Server data always in the same Excel sheet and column instead of creating new Excel sheet and columns. Is that any chance or option are available in Excel or Power Query Editor?

Example:

SQL:

The SQL Server table contains only one column and it’s called supplier.

EXCEL:

I have Excel called Template. In this, I have a one sheet which is called Data with two columns Item Supplier.

I would like to get the supplier column's data from SQL table into existing Excel sheet Data in Supplier column.

Can you please share is there any article already in place also advise is there any Excel supporting tools are available so I can add-in Excel.

I have installed the latest version of MS Office.

[PhilipTreacy · Accepted solution]

Hi @Saxon10 

This is exactly what Power Query is built for.  Looking at your problem you will need to do this in Power Query in Excel, not in Power BI Desktop.

Once you make a connection to your SQL database you load the table into the Power Query editor

After making any transformations you need, click on Close & Load To

and choose to save to a table in your Excel worksheet

Further reading

Introduction to Microsoft Power Query for Excel - Excel

Getting Started with Power Query - Excel (microsoft.com)

Add a query to an Excel worksheet (Power Query) - Excel (microsoft.com)

Regards

Phil

[Saxon10]

thank you so much for your help and advice. This is really nice.