Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamic SQL Query
Is it possible to execute a query independant of a worksheet? For example to run a query that will return data to a variable? -- fazstp ------------------------------------------------------------------------ fazstp's Profile: http://www.excelforum.com/member.php...o&userid=30574 View this thread: http://www.excelforum.com/showthread...hreadid=502211 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamic SQL Query
Yes. Look at ADO: this can be used in a macro without any worksheet
involvement. I'm assuming you mean *database* query (not web query) -- Tim Williams Palo Alto, CA "fazstp" wrote in message ... Is it possible to execute a query independant of a worksheet? For example to run a query that will return data to a variable? -- fazstp ------------------------------------------------------------------------ fazstp's Profile: http://www.excelforum.com/member.php...o&userid=30574 View this thread: http://www.excelforum.com/showthread...hreadid=502211 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamic SQL Query
Tim's right, ADO is the way to go. Check out:
http://www.access-programmers.co.uk/...ad.php?t=59811 Shows how to return an ADO dataset independent of any other object. "fazstp" wrote: Is it possible to execute a query independant of a worksheet? For example to run a query that will return data to a variable? -- fazstp ------------------------------------------------------------------------ fazstp's Profile: http://www.excelforum.com/member.php...o&userid=30574 View this thread: http://www.excelforum.com/showthread...hreadid=502211 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamic SQL Query
Cool, thanks for that. I'll look into it. Basically I'm using excel to query an old dos database and the data returned is too big to fit into a worksheet. I'm hoping to return the data to a variable so I can sort it into seperate tables. -- fazstp ------------------------------------------------------------------------ fazstp's Profile: http://www.excelforum.com/member.php...o&userid=30574 View this thread: http://www.excelforum.com/showthread...hreadid=502211 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
db query with dynamic criteria | Excel Discussion (Misc queries) | |||
Dynamic Web Query from VBA | Excel Programming | |||
Dynamic use of Access query | Excel Programming | |||
Web Query and Dynamic web address | Excel Programming | |||
Dynamic Web Query | Excel Programming |