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

--
Message posted from http://www.ExcelForum.com

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

http://support.microsoft.com/default...73&Product=xlw
SAMPLE: ExcelADO Demonstrates How to Use ADO to Read and Write Data in Excel
Workbooks

http://support.microsoft.com/default...19&Product=xlw
How To Use ADO with Excel Data from Visual Basic or VBA

http://support.microsoft.com/default...46&Product=xlw
How To Transfer Data from ADO Data Source to Excel with ADO

--
Regards,
Tom Ogilvy

"Marek " wrote in message
...
working with data in excel i store data in lists, and if i want to get
some data from lists i must to use for ...to..do to check each row for
my specified conditions....


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


thanks


---
Message posted from http://www.ExcelForum.com/

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

--
Message posted from http://www.ExcelForum.com

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

Robin Hammond
www.enhanceddatasystems.com


"Marek " wrote in message
...
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 query
or to use ADO ?


---
Message posted from http://www.ExcelForum.com/