PASTING OVER MANY FIELDS

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

Guest

How would I go about pasting the same piece of text over many fields? I have tried to do it like one would paste over multiple cells in Excel, but although I select multiple fields, Access will only paste in the first field. Do I have to use a paste special function or something else?
 
create a query

You can switch to sql view and type:

update YourTableName set YourColumnName = "MyNewTExt" where something


MMC @ L&G said:
How would I go about pasting the same piece of text over many fields? I
Click to expand...
have tried to do it like one would paste over multiple cells in Excel, but
although I select multiple fields, Access will only paste in the first
field. Do I have to use a paste special function or something else?
 
How would I go about pasting the same piece of text over many fields? I have tried to do it like one would paste over multiple cells in Excel, but although I select multiple fields, Access will only paste in the first field. Do I have to use a paste special function or something else?
Click to expand...

Pasting isn't really all that appropriate for relational databases,
however well it works in spreadsheets.

If you want to update multiple fields, the most effective way is an
Update Query. You can put the same text on the Update To line of the
query in the design grid, optionally put criteria to specify which
record or records will be overwritten, and run the query.
 
You can select the column you want and paste the value from Excel. It works
just fine , if you are not too sure how to write a query, but keep in mind
Access is a database all related information fall in a record.



M. Madani



MMC @ L&G said:
How would I go about pasting the same piece of text over many fields? I
Click to expand...
have tried to do it like one would paste over multiple cells in Excel, but
although I select multiple fields, Access will only paste in the first
field. Do I have to use a paste special function or something else?
 
Back
Top