Answered

Best Way to Update Rows in Excel with Data from SQL?

(1) Share

Report

Posted on by xexx

Hi everyone,

I have an Excel sheet with user details, containing around 1500 rows. Every week, I run a query against SQL, which returns about 30 rows of modified data. My goal is to update the existing rows in Excel based on the data from SQL.

Here’s my current setup:

I update every column in Excel, except for the "Include" column, which should remain unchanged.
To update the rows, I check whether each SQL row matches the corresponding Excel row by comparing on the "ID_ProvetUserID" column.

However, this process is incredibly slow because it ends up checking 1500 x 30 = 45,000 cases. Does anyone have suggestions for a more efficient way to handle this? My column ID_ProvetUser_ID is unique.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

lbendlin 8,649 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Define the table in Excel, and then run a SQL query against that table with just the updates.

Was this reply helpful? Yes No
Suggested answer

Michael E. Gernaey 53,969 Moderator on at

Like (3)

Report
Copy link

Link copied!

Hi

I would do it in reverse.

1. Run your SQL Query
2. Add an Apply to each for the returned rows
inside
2a. do your List Rows, based on a Filter from the SQL Apply to each, and that unique id you said you have
2b. use a condition to see if you received 1 row
in the Yes (got 1) Update it
in the no (add it)

Now you did zero loops on Excel and only 30 loops on sql

Was this reply helpful? Yes No