Database in Excel

[rparedes]

Hi, is it possible to create a database in excel? What I mean is, can I save details from a worksheet to a different worksheet then I can query it up when needed?

If not, can you suggest alternatives? Thanks

 

[SpillerBD]

Hi, is it possible to create a database in excel? What I mean is, can I save details from a worksheet to a different worksheet then I can query it up when needed?

If not, can you suggest alternatives? Thanks

Details? More detail on the details...

 

[rparedes]

Details? More detail on the details...

Sorry, my english wasn't clear. What I meant was, if I have some data (i.e. Full Name, Address, DOB, Salary) can I create some sort of database in the same excel file?

 

[sandy666]

this is a kind of db in Excel

Date	ID	Name	Company	Country	City	Sales
21/03/2018	16850307-6211	Felix Weiss	Sem LLP	Sierra Leone	Feldkirchen in Kärnten	32638​
18/04/2018	16300905-7245	Maggy Z. Cruz	Malesuada Augue Corp.	Tonga	Curacautín	42560​
02/08/2017	16910128-2987	Melyssa Hale	Mi Corporation	Liechtenstein	Temuka	18179​
19/01/2018	16340924-6224	Beau E. Colon	Ultrices Iaculis Odio Corporation	Kazakhstan	Gouvy	33995​
01/06/2018	16490821-7609	Brenden Roach	Nulla Aliquet PC	Botswana	Meerdonk	15790​
23/04/2017	16590903-0263	Ahmed U. Joyner	Nec Cursus LLP	Fiji	Monte Patria	36711​

you can get details in many different ways in the same workbook (or different workbook if you wish)

for BigData (millions of rows, many tables) I suggest Access, SQL, InnoDB or any similar