How to keep a set of Excel ranges in sync with a set of database tables

markns

New Member
Joined
Jul 26, 2019
Messages
3
Hi folks,

I'm trying to find the best/least-kludgey way to keep a set of Excel ranges in sync with a set of database tables (can be SQL server or MySQL)

Here are the requirements:
  • It must be a one way sync, Excel -> database
  • It doesn't have to be an immediate sync, for example a macro running every 5 minutes is fine. But it should happen automatically, without a user clicking a button.
  • The state of the Excel table should completely replace the state of the database table, including inserts, updates and deletes.
  • There are multiple tables that need to be synced, so something reasonably generic.
Things I've considered:
Sadly nothing seems perfect. Is there anything I'm missing perhaps? Any advice gratefully received.
 

Some videos you may like

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
7,420
maybe try Power Query (Get&Transform) and set refresh time in connections

 

Watch MrExcel Video

Forum statistics

Threads
1,118,852
Messages
5,574,662
Members
412,608
Latest member
Guromir
Top