Starting a new project. the scope is for a good workflow with data from various (up to 8) excel/access files that will be used as back end data storage and a front end gui(excel).
Gui will only create (temp) worksheets. ie once closed the data used by gui will be removed from the workbook (not sure at this point if closeing will save edited data or just dump the data.)
Data will be about 50 columns and for start 50000 rows (this will grow exponentially on a bimonthly bases) . the data will be edited(Via gui(Excel), appended, deleted).
There will be minimal access to the data as a whole.
So the question is this what is better for data storage, extraction and update for speed/use? limited to the use of access db or excel.
Gui will only create (temp) worksheets. ie once closed the data used by gui will be removed from the workbook (not sure at this point if closeing will save edited data or just dump the data.)
Data will be about 50 columns and for start 50000 rows (this will grow exponentially on a bimonthly bases) . the data will be edited(Via gui(Excel), appended, deleted).
There will be minimal access to the data as a whole.
So the question is this what is better for data storage, extraction and update for speed/use? limited to the use of access db or excel.