Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
fill external data in specific cells of various sheet
I need to fill data from oracle (order) into protected workbook (order form)
into various sheet and specific cells. oracle table (model and size is primary key) model size quantity 001 1 1 001 2 1 002 1 4 003 1 2 003 2 2 003 3 1 Excel form A B C D 1 model size/quantity 2 1 2 3 3 001 1 1 4 002 4 5 003 2 2 1 any suggestions to fill easy data from oracle into predefined excel order form.. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
fill external data in specific cells of various sheet
On Dec 10, 8:30 am, "Tomo" wrote:
I need to fill data from oracle (order) into protected workbook (order form) into various sheet and specific cells. oracle table (model and size is primary key) model size quantity 001 1 1 001 2 1 002 1 4 003 1 2 003 2 2 003 3 1 Excel form A B C D 1 model size/quantity 2 1 2 3 3 001 1 1 4 002 4 5 003 2 2 1 any suggestions to fill easy data from oracle into predefined excel order form.. I'd just query the database into a recordset and then loop through the results placing the items you want into the cells you want. Many different ways to skin that cat and I'm sure someone can show you something easier, but that would be my approach. Cory |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I collect specific data from cells in a fill-in form? | Excel Discussion (Misc queries) | |||
fill external data in specific cells of various sheet | Excel Programming | |||
Creating Link to specific Sheet in external excel file | Excel Discussion (Misc queries) | |||
Fill down formulas in cells to the LEFT of external data range? | Excel Worksheet Functions | |||
How can I create a link to a specific sheet from external web page | Excel Discussion (Misc queries) |