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

Hi all:

        Using Google I found some web sites where I could learn my first
lessons about SQL. With this I could solve my problem to Group my data
in BASE.

        But then, I found that the file Spreadsheet that I've using was locked
(user permissions). Well I made a copy of the file with my permissions
and then make the db with Base conection and I could group with Wizard
of BASE.

        Thank so much to all that thought to help me but not had time.


P.D.: Web site I used: https://www.1keydata.com/es/sql/

Regards,

Jorge Rodríguez




El dom, 08-05-2016 a las 21:54 -0600, jorge escribió:
> 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

-- 
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