Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Copy and Paste

Status
Not open for further replies.

wdbouk

Technical User
May 28, 2003
81
CA
hello,

I have a table consisting of one column. I inserted another column and I put a value in the first cell. Then I wanted to copy and paste this cell in the wole inserted column but it pasted only in one cell insted of all the cells. Could anyone tell me how to assign this value for the whole column?
Thx
 
write a query:

UPDATE tblName SET fieldName = "Something" WHERE fieldname = ""

Leslie
 
I also use find and replace.... You copy what you want, put the cursor in the first blank field of that column, go to find replace, the find is blank and paste what you want in the replace, then hit replace all. Thats what I do for bulk work.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top