| View previous topic :: View next topic |
| Author |
Message |
dschmider
General User
Joined: 15 Nov 2005
Posts: 7
Location: UK
|
 Posted: Tue Nov 15, 2005 3:57 am Post subject: Base newby: Linking to external spreadsheet |
 |
|
OK, I am trying to convert from Access/Excel, but a couple of features are either hidden or unsupported in ooo that suprises me..
Basically, I edit an Excel file (cos it has pivot tables etc in it) and then to print it onto a specific form (made of paper - not on PC  ) I link to the excel sheet from a report that is loaded from a query in Access. This query is linked to my excel file.
As I open the report, it prompts me to enter the month & year.. eg "September 2005" then it trundles off and loads my Report with just my records that contain "September 2005" in a particular field.
Basically, It appears I cannot link a table to external data (even an oos file) or indeed provide a prompt in the query for the user to enter.
Is this actually possible?
I hope so as I need to try to make my db available for people who do not own the full microsoft suite.
Thanks in advance
David  |
|
| Back to top |
|
 |
dschmider
General User
Joined: 15 Nov 2005
Posts: 7
Location: UK
|
| Posted: Thu Dec 01, 2005 6:08 am Post subject: |
|
|
So... I take that as a NO then?!
 |
|
| Back to top |
|
|
pitonyak
Administrator
Joined: 09 Mar 2004
Posts: 3618
Location: Columbus, Ohio, USA
|
| Posted: Thu Dec 01, 2005 8:42 pm Post subject: |
|
|
I believe that you can do the same thing as a pivot table in Calc, but it has a different name, data pilot perhaps. I have seen the question asked and answerd on the user mailing list but I do not use the functionality so I paid little attention.
You can link a Base document to a spreadsheet, you simply need to set the data as in an external file. Are you attempting to do somehting different?
_________________
--
Andrew Pitonyak
http://www.pitonyak.org/oo.php |
|
| Back to top |
|
|
dschmider
General User
Joined: 15 Nov 2005
Posts: 7
Location: UK
|
| Posted: Fri Dec 02, 2005 2:24 am Post subject: |
|
|
| pitonyak wrote: |
You can link a Base document to a spreadsheet, you simply need to set the data as in an external file. Are you attempting to do somehting different? |
Thanx for replying.
I have finally managed to link to the spreadsheet which was easy from the startup wizard (once I'd figured it out), and I've also managed to run a query.
However, I only can get it to run when I fill in the query in design mode.
What I really would like, is to have in the criteria a launching of a prompt for a particular field so that it will run the querie base on that choice.
Thanx again
David |
|
| Back to top |
|
|
pitonyak
Administrator
Joined: 09 Mar 2004
Posts: 3618
Location: Columbus, Ohio, USA
|
| Posted: Wed Dec 07, 2005 12:13 pm Post subject: |
|
|
Open the help pages (Press F1). Look at the Base help pages and sear for the following help
queries;parameter queries
You want to use a parameter.
_________________
--
Andrew Pitonyak
http://www.pitonyak.org/oo.php |
|
| Back to top |
|
|
|
