How to connect to SQL server over the internet?

[waimea]

I have an excelsheet with a couple of users, in the sheet I have a datatable with 2 500 rows.

I want to connect to a local or global SQL server and udate the datatable every now and then.

I don´t know where to start? All suggestions are welcome?

Ps. If there are any alternatives to using a SQL, I am open to alternatives?

[mancubus]

https://simpleexcelvba.com/how-to-connect-to-microsoft-sql-server-using-vba/
https://excelk.com/en/vba-and-sql-server/
https://www.encodedna.com/excel/connect-and-pull-data-from-sql-server-in-excel-using-vba.htm

[mancubus]

you can find many resources.

giybf :devil2: