how do i copy the same cell in a full column

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

Guest

I have a databas with thousands of entries. I would like one column to have
the same word. how do i paste the same word in the column?
 
You would create and run an update query.

UPDATE SomeTable SET SomeField = "some word";
 
sparker said:
I have a databas with thousands of entries. I would like one column to
have the same word. how do i paste the same word in the column?
Click to expand...

Joan told you how, I am going to ask "Are you sure you want to do this?"

It sounds like you are not using a database properly. You should never
need all the records to contain the same data, unless you are going to
change it in the future.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

In access, how do I paste a phrase into every cell of a column? 2
Excel A CountIF question... I think 2
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Split column contents (de-concantenate) 7
Excel Help to copy information from one row at a time to another sheet 1
How do i turn my database into multiple documents? 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
VBA set thick borders around non empty cells in range 0

Back
Top