Tracking data imported to a database

[Neil]

I have designed a database that imports from spreadsheets
into a table in the Database.

I want to know if there is any way of tracking when data
is imported to the table so that no duplicates are
imported and the user can find out when the last import
was.

Thanks

Neil

 

[Axel]

You can have a field "createDate" with a default value now
(). Then you can identify all records imported on this
day. I'm not sure though, whether the default value is
used on importing a spreadsheet.

It is possible to link to the spreadsheet as if it is a
normal table. Then create an append query, that checks for
existing entries in the Access table and only appends new
records. In the same query you can fill the "createDate"
field.

 

[Neil]

Do you mean just create a field and call it createDate, or
is there a way to have createDate as a field type?

 

[Axe]

Yes,

createDate is just a name, you can use any name you want.
The date of creating comes into this field with the
default value.