append query? update query?

[colleen]

I have text I need to repeat on every line of an 81,000
row table....
Copy & paste doesn't work.
I need to know where & how I can 'fill in'/append/update
the entire table with the same info. I did this a year
ago, and can't remember how to do the query other than it
involved "xxx" quotes around my text I want to repeat
Thanks

 

[Kevin3NF]

Assuming you want to insert the string 'Some Text' into a field called
'blah' in Table1:

UPDATE Table1
SET Table1.blah = 'Some Text';

This will replace the existing contents of field blah.

Updating changes existing rows, Appending adds new rows to the table.


--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

 

[Kevin3NF]

for clarification, this will relace the contents of field blah in EVERY
record.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm