| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I Consolidate an EXCEL Report into a record for ACCESS impo
How can I set create a VBA program that can arrange a multi-row EXCEL 2007
report by consolidating the lines into one record to import it into ACCESS 2007? Example: How can I convert all of the information below into one record? Location Title DATE Prev Current Used Cost Sold Purchased Liquor 14407.60 14767.66 819.71 $535.32 731.00 $731.30 Wine 21399.49 21989.17 931.93 $404.89 1211.06$441.72 Beer 1417 1268 341 $297.78 333 $163.60 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Consolidate report in Different sheet | Excel Discussion (Misc queries) | |||
| Linking Excel and Access to import a single record from DB | Excel Worksheet Functions | |||
| How do I consolidate 2 tables into 1 pivot report? | Excel Discussion (Misc queries) | |||
| Obtaining a single Access record from Excel input | Links and Linking in Excel | |||
| record an excel macro, save on network so that everyone can access | Excel Discussion (Misc queries) | |||
Threaded Mode
