General discussion


MS Access - Automate Records

By jgreer ·
I am currently working on a mailing management database and have a problem with it. There are going to be about 1,000 records imported into it but they need a date of import added into a field in the table the same time we pull the records into it. It will be using an Excel spreadsheet and then imported, how can I automate the entry of the date into these records without having to manually enter it into each one?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by sgt_shultz In reply to MS Access - Automate Reco ...

you mean you just need to datestamp the 1000 records? easy once they are imported into Access, create the field 'importdate' the create and update query and put the date in that field...does that help?

Collapse -

by jgreer In reply to

Poster rated this answer.

Collapse -

by jgreer In reply to MS Access - Automate Reco ...

This question was closed by the author

Related Discussions

Related Forums