question about SQL in EXCEL

[MKLAQ]

Hi experts,

I need know about SQL in excel . is that individual programme and link with excel or is existed insied the EXCEL programme?

if is existed inside EXCEL programme .how show and what is its function and what's its useful?

is there any tutorial to learn about it?

 

[JEC]

You can use sql but it does not have the same functionallity as in sql server for example.

Furthermore, you need to load an object with an ADOdb connection, before you can use sql .

 

[MKLAQ]

Furthermore, you need to load an object with an ADOdb connection, before you can use sql .

what aim to use SQL and for waht use it , and which case I have to use it and waht I bnefit from it ?

 

[JEC]

You can extract data from databases with sql. Better use power query for this. Standard available in Excel and very user friendly. With only clicking buttons you can extraxt, transform and load the data