[libreoffice-users] Base-Conect an external spreadsheet data

Good night, hi all:

        I have two options when I conect to a external spreadsheet data with
BASE:

1) Conect with the third option when start the wizard selecting:
spreadsheet.

In this case we can import the structure and data from it.

The first options is keep the conections with the original spreadsheet,
in other words, we can't modifie the structure import and use functions
when make a Consult for example (At least with my little knowledge).

Depend what you are going to do with data, is enough as is.

2) The second option is when we conect to external data because we need
to work we them with all options that usually offer BASE when we create
a new data base. In this situations we need import data but then split
conection with original data and make an independent data base.

At least I can't do this with BASE.

Would you please answer this:

a) With SQL options we can use the function "group" or other funtions
when make a Consult to solve my problem ? or with a Macro ?

b) If not (Point a)), where I can expose this situation that would be
improbe BASE in the future ?

-- 
Atentamente,

Jorge Rodríguez


-- 
To unsubscribe e-mail to: users+unsubscribe@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