hello all,
looking for advice for the best way to view information from an sql database.
i need the info to be refreshed everytime its open. the excel sheet will be stored on a sharepoint so that anytime anyone opens it the table refreshes with the data.
its the best way to do this... VBA SQL code?
looking for advice for the best way to view information from an sql database.
i need the info to be refreshed everytime its open. the excel sheet will be stored on a sharepoint so that anytime anyone opens it the table refreshes with the data.
its the best way to do this... VBA SQL code?