Excel database
I usually do this manually. I add a date to the xls file name like
myworkbook 2007-06-20.xls. Each day I use window explorer and copy and paste
old workbook to create a new workbook. Then rename the file to change the
date. I then open the new file and make changes. I now have a history of
all the changes.
"JoJo" wrote:
Folks:
I have a small spreadsheet consising of 5 columns & 10 rows of information.
Each day I manually update this spreadsheet so I end up with a new set of
data in the rows & columns.
But this means that the previous day's data is lost.
* Is there a way to create (then save) each day's data to a database so
that I can always go back to check on the old data ?
When I enter data in the spreadsheet, it should get stored in this database.
The spreadsheet is merely acting like a FORM thru which data gets sent to
the database.
Thanks,
Jo..
|