Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel's database features
I don't know anything about excel's database features. Can SQL be used in Excel?
Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel's database features
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 "Asif" wrote in message ... I don't know anything about excel's database features. Can SQL be used in Excel? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Features greyed out | Excel Discussion (Misc queries) | |||
Security Features? | Excel Discussion (Misc queries) | |||
autocorrect features | Excel Worksheet Functions | |||
I would like to see a few new features in Excel | Excel Worksheet Functions | |||
Charting Features | Charts and Charting in Excel |