Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel database
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.. |
#2
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel
|
|||
|
|||
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.. |
#3
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel
|
|||
|
|||
Excel database
Sure, just write the code that writes the data to your database (assume Access)
http://www.erlandsendata.no/english/...php?t=envbadac -- Regards, Tom Ogilvy "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.. |
#4
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel
|
|||
|
|||
Excel database
Tom: Read my response. Jo wants to have a history of the data sent to access.
either Jo need to save the worksheets each day under a different name or send different rows of data each day to the access db. Maybe Jo should arrange worksheet so first day data is on rows 1 - 10. Second day data is on rows 21 - 30. Third day data on rows 41-50. Then select range of data to send to access before running macro. Macro will use selected cells? "Tom Ogilvy" wrote: Sure, just write the code that writes the data to your database (assume Access) http://www.erlandsendata.no/english/...php?t=envbadac -- Regards, Tom Ogilvy "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.. |
#5
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel database
Why not just write a simple macro that copies the worksheet and renames it
to the day's date. You could manually go and purge old unwanted sheets. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) <JoJo wrote in message ... 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.. |
#6
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel
|
|||
|
|||
Excel database
Joel,
Using ADO to write the existing data to an access database doesn't require any of those steps. Send the data, change the data, send the data, change the data, . . . Granted, he would probably need a date field, but the data may already have that. If he wants to maintain the record by creating a new workbook each day or on a second worksheet, then what you suggest may be needed. -- Regards, Tom Ogilvy "Joel" wrote: Tom: Read my response. Jo wants to have a history of the data sent to access. either Jo need to save the worksheets each day under a different name or send different rows of data each day to the access db. Maybe Jo should arrange worksheet so first day data is on rows 1 - 10. Second day data is on rows 21 - 30. Third day data on rows 41-50. Then select range of data to send to access before running macro. Macro will use selected cells? "Tom Ogilvy" wrote: Sure, just write the code that writes the data to your database (assume Access) http://www.erlandsendata.no/english/...php?t=envbadac -- Regards, Tom Ogilvy "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.. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to make reference to database and if true copy from database? | Excel Discussion (Misc queries) | |||
Moved database, how do I change link to the database in excel | Excel Discussion (Misc queries) | |||
Transforming messy database into clean database | Excel Discussion (Misc queries) | |||
Database and Excel | Excel Discussion (Misc queries) | |||
Excel and IBM bd2 database | Links and Linking in Excel |