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

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

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

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

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

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