| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
Data Query on the Fly
Does anybody have a Data Query on the fly example?
I would like to query a Microsoft Access database and stuff the results into a new table. Can anybody help? I have used the External Data Function but would like to customize the SQL with data from the XLS sheet to return different results. Thank you in Advance, Mike |
|
#2
Posted to microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
|
Data Query on the Fly
Not exactly sure what you want to do, but perhaps
http://www.erlandsendata.no/english/...php?t=envbadac http://support.microsoft.com/default...b;en-us;257819 How To Use ADO with Excel Data from Visual Basic or VBA will be of some help. -- Regards, Tom Ogilvy "Michael Kintner" wrote: Does anybody have a Data Query on the fly example? I would like to query a Microsoft Access database and stuff the results into a new table. Can anybody help? I have used the External Data Function but would like to customize the SQL with data from the XLS sheet to return different results. Thank you in Advance, Mike |
|
#3
Posted to microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
|
Data Query on the Fly
You can also make you External Data query dependent on cell values:
http://nickhodge.co.uk/gui/datamenu/...taexamples.htm http://www.dicks-clicks.com/excel/Ex...htm#Parameters -- Regards, Tom Ogilvy "Tom Ogilvy" wrote: Not exactly sure what you want to do, but perhaps http://www.erlandsendata.no/english/...php?t=envbadac http://support.microsoft.com/default...b;en-us;257819 How To Use ADO with Excel Data from Visual Basic or VBA will be of some help. -- Regards, Tom Ogilvy "Michael Kintner" wrote: Does anybody have a Data Query on the fly example? I would like to query a Microsoft Access database and stuff the results into a new table. Can anybody help? I have used the External Data Function but would like to customize the SQL with data from the XLS sheet to return different results. Thank you in Advance, Mike |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use MS Query to query data within the current work book | Excel Discussion (Misc queries) | |||
| Importing Data via Web Query - Can values be passed to query? | Excel Discussion (Misc queries) | |||
| Save data retreived from query without saving query | Excel Discussion (Misc queries) | |||
| How to Process Query Data after Query is Refreshed | Excel Programming | |||
| Query returning more data than will fit on worksheet with VBA DB query... | Excel Programming | |||
Linear Mode
