Hi.
You won't be able to paste an entire column into a table unless the rest of
the fields in each record are not required fields in an already defined
table, or the table is a brand new table opened in Datasheet View without
any fields defined. All you need to do is select the field name in the
column's header to highlight the entire column, then paste the text column
into it. The data type for the field must be text if this is a table that
has fields that are already defined.
You won't be able to paste an entire row into a table unless the field
order, data types, and field lengths of the copied row are similar to the
fields in the table pasted into, or the table is a brand new table opened in
Datasheet View without any fields defined. If the copied record has more
fields than the table to be pasted into allows, the extra fields will be
truncated. All you need to do is select the record selector to the left of
the row where you want to paste the record, then paste the record into it.
HTH.
Gunny
See
http://www.QBuilt.com for all your database needs.
See
http://www.Access.QBuilt.com for Microsoft Access tips.
(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
