automatically make entry in a table - help needed urgently

[djsmarties]

hi there,

i have a database where i import data from excel into access tables. One of the access tables is not updated via excel and would need to be updated manually ("only access table").
what i need:
is it possible that during the import action from excel access also makes a new record in the "only access table" for every record it imports from excel?
basically it would just have to paste two fields from one table into this "only access table".

Any ideas? thanks for helping.

 

[Corticus]

Hi,

You could make a new table that had a record for everytime a new record was imported using an append query. I would set up a table, make one field a foreign key from the primary key of your imported excel table, and one field a date field. In the append query, I would append the date field to now(), and append the foreign key field from the primary key of the source table. That way you would have a table with:
1. A key to indicate every record imported and
2. A date for each imported record.

HTH,
Corticus
This message was edited by Corticus on 2002-12-12 08:43