Direct access to Microsoft SQL Database?

A very easy way is to use excel and MSQuery to directly query the database. A simple query can be written with a parameter (tied to a cell). The SQL database will have to be set up as read only for the user. One would also have to be a windows user on the network to utilize it.

Have you looked at the excel oData examples in the help?

yes.

1 Like