Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is there any way to use SQL directly inside Excel to return a value from a
table to a cell, both in the same worksheet, without using ODBC? I seem to remember being able to do this in 123. I would prefer to do this by entering the SQL into a cell, but a VBA function would work also. Any help would be appreciated. I'm a mainframe guy, a little lost in Excel trying to help my daughter. In case you wonder why: I want to look up a value in a table that is 3 cols by 30,000 rows. I need to match two columns and return the third. I tried to convert the table to two dimensions with the pivot table wizard, but although it seemed to work, it discarded many chunks of data. I know SQL a lot better than I know Excel's lookup functions. This needs to run on a version of Excel without the ODBC add in, and no authority to ad it in. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
imbed Word document in EXCEL | Excel Discussion (Misc queries) | |||
Can I imbed a Word Document into an Excel Workbook? | Excel Discussion (Misc queries) | |||
Excel should let me imbed documents and programs within its-self | Excel Worksheet Functions | |||
Imbed Linked Word doc in Excel so whole doc shows? | Excel Discussion (Misc queries) | |||
How do I imbed a Word document into an Excel cell? | Excel Discussion (Misc queries) |