I have a Stored Procedure in MS SQL Server 2005 that I'm usnig in EXCEL to import data into a spreadsheet.
Not all of our users have EXCEL....most have OPEN OFFICE.
QUESTION: Can OPEN OFFICE be setup to IMPORT DATA using a Stored Procuedure from MS SQL Server...??? And if so,....HOW......? I cannot find the menu to set it up.
I can see where I can "LINK" to other data sources like OTHER Sheets...but no place that I can input SQL Commands....???