Insert Default Date/Time Value into a Database Table
Posted on 2015-02-05
I wondered if there is an easy way of inserting one Date/Time value to all of my records in a database table. Here is a summary of the situation. I have been assigned a Membership Directory that is in excel format. I have already imported the data into an access database table and made some changes. We realized that we wanted to keep track of the dates that new members joined. Therefore, we created a date time field that we will update going forward. The question is, can we input one date (say 01/01/2015) into all of the current records, which is approximately 5,000 strong?