Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

Excel - Subquerys

2 Posts 2 Posters 0 Views 1 Watching

S Offline
S Offline
shopi30

wrote on last edited by

#1

Hi Code Project Team. Someone know if it's porssible make subquerys in Excel using OleDb?

SINCERELY. ANTHONY ACUÑA PREFERED PHRASE: SOMEBODY TELL ME WHY IS MORE REAL WHEN I DREAM THAT I AM WAKE?
G 1 Reply Last reply

0
S shopi30

Hi Code Project Team. Someone know if it's porssible make subquerys in Excel using OleDb?

SINCERELY. ANTHONY ACUÑA PREFERED PHRASE: SOMEBODY TELL ME WHY IS MORE REAL WHEN I DREAM THAT I AM WAKE?
G Offline
G Offline
George L Jackson

wrote on last edited by

#2

The Microsoft.Jet.OLEDB provider supports IN, ANY/SOME/ALL, and EXISTS subqueries. Thus, you should also be able to make these subqueries with Excel. I have not tested this, however.
1 Reply Last reply

0

Log in to reply