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

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

sandy666

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

 

Watch MrExcel Video

Forum statistics

Threads
1,118,415
Messages
5,571,975
Members
412,430
Latest member
Huuktkt
Top