| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
help with macro to query data from DB
Hello, I wanted to see if somebody could me create a macro that could
retrieve data from a .mdx file and place the data into an excel worksheet. I would like the user to type the following information into an worksheet to define the DB file path and field names to import. cell A1 user types the name of .mdx file to import data from. cell A2 STULINK - field name cell A3 PermNum - field name cell A4 Ln - field name cell A5 Fn - field name Any help would be appreciated. Thanks, -- Regards, timmulla |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Web query: Want to pause macro while Web query completes refreshin | Excel Programming | |||
| external data automatic refresh through macro/query | Excel Discussion (Misc queries) | |||
| another macro query - deleting a worksheet within a query | Excel Discussion (Misc queries) | |||
| How can I Run a query from VB macro with out affect current data in the same sheet? | Excel Discussion (Misc queries) | |||
| Macro to query data from a succession of websites and display in seperate sheets | Excel Programming | |||
Threaded Mode
