Tools & Solutions for the Information Worker


Home
Overview Approach Products Services Projects
Microsoft Access
> CellHouse
Microsoft Excel
xlDataLink
xlWorkbench
xlRollUp

CellHouse:  Database Storage for Spreadsheet Data


CellHouse is system that extracts cell-level data from Excel workbooks and stores it in a Jet database.  With the data stored in this structured fashion, all the power of the Access query and reporting features can be applied to it, giving the user flexible new ways to validate the contents of individual workbooks and to view collections of workbooks in the aggregate. [in development]

  • Comprises a cell storage database, a job definition database, and an Access client program.
  • Allows the user to define and run jobs that extract data from tens or hundreds of workbooks in one operation.
  •  Provides optimized features for querying and viewing extracted data based on cell attributes.

More...

 

 

Copyright© 2003-2007 Robert S. Buckles All rights reserved.