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 Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

fill table column down

Status
Not open for further replies.

kmayo503

MIS
Jun 21, 2003
70
US
is there a way to fill a column with the same information. i have tried everything from highlighting and pasting, changing settings; and i still have to fill in the same info by hand. any help would be great.
 
try
update table XXX set column_name = 'aaa'
 
forgive my ignorance, but what am i suppose to do? i don't know where to put that?
 
Are you using Microsoft SQL Server (which is what this forum is for)?


-SQLBill
 
no i am not setup in sql. this is just for a table. there isn't a forum for tables anywhere. so i posted it under sevral to see if anyone knew anything.
 
What kind of table? No one can help if they don't know what program you are using.

And you are right, there isn't a forum for 'tables'. But there's probably a forum for whatever program you are using.

I'm going to take a guess that you are using Microsoft EXCEL. There is a forum for that. But this is the solution:

Click once on the cell with the information you want to 'copy' into the rest of the column or row. That puts a black box around the cell, use the cursor and 'grab' the lower right corner of the cell (put the cursor over the lower right corner and hold down the left mouse button). Drag the lower left corner in the direction you want the 'copy' to happen, when all the cells are shaded, let go of the button.

-SQLBill
 
no i am using access. the tables section of the program doesn't let you copy down. i have been looking for a way to do that for years.
 
There are forums for Microsoft Access. Go to the search at the top of this page and enter Access in the left box, Find a Forum in the right box and then click on GO.

-SQLBill
 
By the way, this might help:

Click on one of the links for Access in my signature block:



SELECT 'forum' CASE [SQL TYPE]
WHEN 'MySQL' THEN 'forum436'
WHEN 'Access' THEN 'forum700', 'forum701', 'forum702', 'forum703', 'forum704', 'forum181'
WHEN 'ORACLE' THEN 'forum185' 'forum186', 'forum759'
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top