Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Does SQL.REQUEST work in Excel X?
Does SQL.REQUEST work in Excel X under OSX? Thanks.
|
#2
|
|||
|
|||
No. Use Microsoft Query to run a query from the worksheet instead.
In article , mrl wrote: Does SQL.REQUEST work in Excel X under OSX? Thanks. |
#3
|
|||
|
|||
How does one create a dynamic SQL query then? I.e. I need to take data
from the spread sheet, such as an account number and date, and use that in the SQL query. Thanks. JE McGimpsey wrote: No. Use Microsoft Query to run a query from the worksheet instead. In article , mrl wrote: Does SQL.REQUEST work in Excel X under OSX? Thanks. |
#4
|
|||
|
|||
mrl
You need a parameter query. See here http://www.dicks-clicks.com/excel/Ex...htm#Parameters and here http://www.dicks-blog.com/archives/2...-data-queries/ -- Dick Kusleika Excel MVP Daily Dose of Excel www.dicks-blog.com mrl wrote: How does one create a dynamic SQL query then? I.e. I need to take data from the spread sheet, such as an account number and date, and use that in the SQL query. Thanks. JE McGimpsey wrote: No. Use Microsoft Query to run a query from the worksheet instead. In article , mrl wrote: Does SQL.REQUEST work in Excel X under OSX? Thanks. |
#5
|
|||
|
|||
Unfortunately, Excel for the mac has little of the functionality of
Windows Excel, and doesn't have the Querytables collections. I'm seriously thinking of buying virtual PC so I can run Windows Excel! :) Dick Kusleika wrote: mrl You need a parameter query. See here http://www.dicks-clicks.com/excel/Ex...htm#Parameters and here http://www.dicks-blog.com/archives/2...-data-queries/ |
#6
|
|||
|
|||
That could be a good idea regardless, I have Windows desktop with Office
2003, virtual pc for windoows on that same desktop running win98 and Office 2002 (XP), Linux with openoffice and Swedish winxp running Swedish Office XP, then I have a powerbook running Office 2004 and with virtual PC running Office 2003. I love the powerbook but I am not too handy with Office 2004 yet so I can always run the windows version on the virtual pc if I need to check something to make sure it works in both versions -- Regards, Peo Sjoblom "mrl" wrote in message ... Unfortunately, Excel for the mac has little of the functionality of Windows Excel, and doesn't have the Querytables collections. I'm seriously thinking of buying virtual PC so I can run Windows Excel! :) Dick Kusleika wrote: mrl You need a parameter query. See here http://www.dicks-clicks.com/excel/Ex...htm#Parameters and here http://www.dicks-blog.com/archives/2...-data-queries/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do I update Excel 2000 macros to work in Excel 2002? | Excel Discussion (Misc queries) | |||
can a workbook with macros created in excel 2003 work in excel 20. | Excel Discussion (Misc queries) | |||
transfer an excel work sheet to Paint | Excel Discussion (Misc queries) | |||
transfer an excel work sheet to Paint | Excel Discussion (Misc queries) |