Export to acces "on click"

[Mesktomten]

Hi!

I've got a spreadsheet that contains a couple of projects and their status. If I change status to one of the projects I would like the updated row to be inserted into an access database with a timestamp. Preferabally this would be done via an "update button" on each row.

Example
Excel:
Projectname, Status, Column 3
Project 1, Ok, "updatebutton"
Project 2, Critical, "updatebutton"
Project 3, Ok, "updatebutton"

Access:
Projectname, Status, Updated
Project 1, Ok, 2010-01-01
Project 2, Ok, 2010-01-02
Project 3, Ok, 2010-01-03
Project 2, Critical, 2010-01-04


If I change status to project 2 the table would look like this:
Projectname, Status, Column 3
Project 1, Ok, "updatebutton"
Project 2, Ok, "updatebutton"
Project 3, Ok, "updatebutton"

And if I hit the update button I would like the database to look something like this:
Projectname, Status, Updated
Project 1, Ok, 2010-01-01
Project 2, Ok, 2010-01-02
Project 3, Ok, 2010-01-03
Project 2, Critical, 2010-01-04
Project 2, Ok, 2010-01-05 (new)

Is this possible, and how do I do it?

/Martin

[tony h]

Hi,

there are several ways to achieve the sort of effect that you describe. Unfortunately the one closest to what you want will give you a real problem that is difficult to resolve unless you have a lot of experience.

So what I suggest is that the spreadsheet is coded the way you describe but instead of writing to access you write to a table (sheet) in the workbook.

Then in access create a linked table using the Excel workbook as the source. It is then easy to import the data table to update Access.