troubleshooting Question

Can OPEN OFFICE retrieve data via SQL Stored Proc like MS Excel....????

Avatar of Marcus Aurelius
Marcus AureliusFlag for United States of America asked on
LibreOffice
5 Comments1 Solution1772 ViewsLast Modified:
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....???

Thanks
MIkeV
ASKER CERTIFIED SOLUTION
ltlbearand3

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros