I have an application where a supplied data source is an Excel spreadsheet. This spread sheet is a matrix consisting of locations as rows and stocked items as columns. (I have no control over the spread sheet design!) Store# ItemA ItemB ItemC ItemD ..... 0100 Y N N Y 0200 Y Y N N 0300 N Y Y N 0400 N N N Y etc. This spread sheet is updated regularly, with stores added or removed (# of rows), stock items added or removed (# of columns) and the store information changed. (Y/N) Currently there are 1950 rows in the spread sheet and 157 items (columns). I need to link Rbase to this spreadsheet and be able to run routines against store# and what items each store stocks, etc. Such information such as # of stores that ItemA is stocked in, how many items Store 0100 has. etc. etc. Any thoughts on an efficient method as to link this continually changing data into Rbase table(s). ? A simple table with Store Number and Item number would have 306150 rows of data. (1950 x 157) and would also be difficult to populate from the above matrix. Innovative ideas appreciated! Thanks- Bob
