Re: [libreoffice-users] Link Base to External Spreadsheet

On 02/16/2013 07:32 PM, Dan Lewis wrote:
> On 02/16/2013 07:04 PM, Mark LaPierre wrote:
> > Hey All,
> >
> > I need to link a database to several external spreadsheets.
> >
> > A.> If I use the DB wizard to create a DB linked to a spreadsheet I
> > get the table named by the name of the tab inside the spreadsheet.
> > That's great but I can not add any more tables, linked or otherwise.
> >
> > B.> If I add a new table by opening a spreadsheet in Calc, and then
> > selecting the data in the spreadsheet, copying, and then pasting it
> > into Base, with the table icon selected, I get a table with fixed data.
> >
> > I need to do A.> to link to multiple external tables. I also need to
> > be able to create additional tables that are not links to external
> > spreadsheets.
> >
> > A few weeks of perusing the manual, google, and the help files has not
> > provided an answer.
> >
> > Maybe I need to use MS Access.
> >
> > Any suggestions?
> You are using Base to connect to a spreadsheet. Because of that, you can
> only add, modify, nor remove data within the spreadsheet. So, if you
> want to add more tables, add more sheets that each has the data for a
> new table. Then save the spreadsheet, close and then reopen Base. The
> new tables should show up in the database. And as you have discovered,
> you will want to name each new sheet with the name you want for the table.
> I've done this several times.
>
> --Dan

Thanks Dan,

Now how do I create non-linked tables inside the same DB?

How do I link to another external spreadsheet using the same DB?

Can I link to only one spreadsheet at a time?

I have data in four different spreadsheets that I need to consolidate 
into one large report.  The data in those spreadsheets changes every 
week.  I don't want to have to copy and paste the data from those four 
spreadsheets onto the appropriate tab of linked spreadsheet every week.

From your email I gather that all tables must be tabs on the one 
spreadsheet that is linked.  Is that a true statement?  Seems pretty 
inconvenient.

--
    _
   °v°
  /(_)\
   ^ ^  Mark LaPierre
Registered Linux user No #267004
https://linuxcounter.net/
****

--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted