asked on

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

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

ltlbearand3

I don't have a SQL server to test with, but lets see what we can do. To see the data source are you using F4 (which is View
| Data Sources)?

Also, I suggest posting to the community advisor and having them add this to the MYSQL zone. We might find someone in that community who has a quicker answer.

Marcus Aurelius

ASKER

I think my main question is:

How do you ADD a datasource....? I think I can see how..but it doesn't give me the option of setting up a MS SQL Server 2005 database...?

Thanks
M

ltlbearand3

First you need to create the ODB file connect.

I prefer to do this with the wizard in OOo Base.
Choose connect to an existing Database
Select MySQL (towards the top of the list) and follow the prompts.
If you get an option to register the database, select this option.
Then save the odb file somewhere.
Now when you press F4 in Calc, you should see the database connection.

Marcus Aurelius

ASKER

Use "MYSQL" even though I use Microsoft SQL Server 2005???

ASKER CERTIFIED SOLUTION

ltlbearand3

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial