| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
MS Query
I'm running Excel 2000. I was reading somewhere that I can type a SQL query
directly into the Excel OLE DB Query dialog box command text field, but I can't see how to do that at all following the sequence to get external data. I start at Data, Get External Data...it seems the only relevant choice is New Database Query...but, I don't see any such access to a query dialog box command text field where I could type in my SQL. Exactly how would I do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Save data retreived from query without saving query | Excel Discussion (Misc queries) | |||
| Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
| Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
| Microsoft Query rejects "nz" function in Access Query | Excel Discussion (Misc queries) | |||
| How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
Threaded Mode
