How do I autofill an empty column in Access 2000?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an existing database file that I need to auto fill an empty column
with the same information. Is there a better way to do this than copy & paste
106,000 times?
 
I have an existing database file that I need to auto fill an empty column
with the same information. Is there a better way to do this than copy & paste
106,000 times?
Click to expand...

As suggested, an Update query, with no criteria (so it hits all rows).

But I must ask - WHY would you want to fill 106,000 rows redundantly
with exactly the same value? What purpose does this new field serve??

John W. Vinson[MVP]
 
Mr. Vinson:
I am a physical security expert and our access control database of
cardholders needed to have a clearance added to all records. Since the only
manner which to complete this is to export the cardholder database to a
database application such as Access or Excel, populate one of the columns
with said clearance, and then import the data back into the access control
database.

Thank you for your resoponse. I was able to complete this task in a timely
manner for my client.

Bobby
 
John Vinson said:
As suggested, an Update query, with no criteria (so it hits all rows).

But I must ask - WHY would you want to fill 106,000 rows redundantly
with exactly the same value? What purpose does this new field serve??

John W. Vinson[MVP]
Click to expand...
 
Back
Top