Excel's database features

A

Asif

I don't know anything about excel's database features. Can SQL be used in Excel?

Thanks.
 
R

RADO

You can use SQL to manipulate external data but Excel has to be connected to a SQl engine (i.e, Jet or MS SQL etc)
It does not have built-in SQL engine (to the best of my knoweledge.
The way around is to use advanced filter. You can write procedures based on advanced filter to imitate simple SQL features (like single table SELECT etc. Obviously, no joins :-(

Cheers -
RADO
I don't know anything about excel's database features. Can SQL be used in Excel?

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging from an Excel file with graphics 1
CRM concept 0
Making "Change Highlighting" feature darker 1
Replacing a phrase with carriage returns 1
How can I install Publisher in 365 Enterprise? 1
Only Files received through email are being blocked 0
ASK Field Formatting 1
Blocking users from outside office 0

Top