SQL Server to connect to MS Excel

Hi All,

I know that MS Access can be connected to MS Excel (saving, updating, deleting, navigating records)

My next question is, is it possible for MS Excel to (navigate, update, delete, and save records) in MS SQL Server?

Since SQL and Access is somehow the same it should work right?

Need your advise.

Thanks.

Yes, with two minor adjustments:
Both use the ADO class, so you have access to the same properties and methods.
The connection string is different. You need to search the connection string for SQL in "My connection site".
The SQL Server statements are slightly different. I think SQL Server has more functionality and features than Access.

This site has the connection string for Access and SQL server.
https://www.connectionstrings.com/

Thanks AB33.

Helpful indeed!