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+unsubscr...@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