Base-Conect an external spreadsheet data

users
#1

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 ?

#2

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