using Database in EXCEL ?

[Marek]

working with data in excel i store data in lists, and if i want to ge
some data from lists i must to use for ...to..do to check each row fo
my specified conditions....


it is possible to use any normal database in excel, where i can use sq
statement ?


thank

 

[Tom Ogilvy]

http://www.erlandsendata.no/english/index.php?t=envbadac

http://support.microsoft.com/default.aspx?scid=kb;en-us;278973&Product=xlw
SAMPLE: ExcelADO Demonstrates How to Use ADO to Read and Write Data in Excel
Workbooks

http://support.microsoft.com/default.aspx?scid=kb;en-us;257819&Product=xlw
How To Use ADO with Excel Data from Visual Basic or VBA

http://support.microsoft.com/default.aspx?scid=kb;en-us;295646&Product=xlw
How To Transfer Data from ADO Data Source to Excel with ADO

 

[Marek]

thanks, all this examples is good

but maybe you know any links like

using ado with access db in excel step by step
or ado in excel step by step

i cant find any normal full tutorials, only examples,



at this point i want to ask, what is better to choose, microsoft quer
or to use ADO

 

[Robin Hammond]

Excel 2002 VBA by Bullen, Green, Rosenberg and Bovey has a good section on
the use of ADO.

Robin Hammond
www.enhanceddatasystems.com