Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
SQL query from one excel worksheer to another one in the same book
Hi,
I have an Excel book with 2 sheets. One of them is just a copy & paste table from Access (I mean, just columns with a header). The other one is a dynamic sheet that must be filled from the first sheet. I need to fill it with several conditions, say I want all data from column "user" but only if the user has "25" years. I was thinking about using an SQL query to that worksheet, which is in the same book as I pointed before, to get the data (and I canīt use Access). Can I do that? Thanks in advance. Vicente. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert full row from worksheer to another base on condition | Excel Discussion (Misc queries) | |||
Use MS Query to query data within the current work book | Excel Discussion (Misc queries) | |||
copy worksheets to new book without linking to original book | Excel Discussion (Misc queries) | |||
Upload worksheer? | Excel Discussion (Misc queries) | |||
'BeforeClose' code problems:book won't close if more than one book is open | Excel Programming |