Software

Ask something
Discussion Locked

MS Access - Automate Records

0 helpful
3 replies

by jgreer 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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?

3 replies

by sgt_shultz

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?

This discussion is closed to new replies.