Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extractind data from external database
Hello
I am trying to extract multiple data sets from multiple tables in a external database. Currently I have to Edit each query so as t nominate the information I require. Is there a way I can do this (using VBA/user forms etc) that wil populate these editable fields for me without having to edit each quer in turn? Ta -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extractind data from external database
The preferred method is to write a stored procedure in the RDBMS and
invoke it with the client passing the required values as parameters. Use an appropriate control (textbox, combobox, etc) on the userform and extract its Value property. Use ADO: a Connection object to connect to the RDBMS and invoke the stored procedure (with parameters) and rs objects to capture the resulting data sets. -- TOMMO wrote in message ... Hello I am trying to extract multiple data sets from multiple tables in an external database. Currently I have to Edit each query so as to nominate the information I require. Is there a way I can do this (using VBA/user forms etc) that will populate these editable fields for me without having to edit each query in turn? Ta T --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing data via an external database query | Excel Discussion (Misc queries) | |||
Tool bar: Data/Import external data/New database query | Setting up and Configuration of Excel | |||
when importing data from external database does not load into wor. | Excel Discussion (Misc queries) | |||
How do I use Excel to post data to an external database? | Excel Discussion (Misc queries) | |||
Extractind Data (Updated Emaple) | Excel Programming |