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..