copy & paste

[colleen]

it should be easy, but apparently i'm not doing something
right. I'm attempting to copy & paste data from row 1 to
the end of the table. I tried edit,append paste, but all
it does is add the text on the LAST record, and not the
other 70,000 rows.
Thanks

 

[Cheryl Fischer]

If you are trying to fill a single field in your table with data, you will
need to create an Update Query:

1. From the database window, select Query, then New. Click OK, then
select the table which has the field to be updated, adding it to the upper
portion of the Query Designer.

2. Right click anywhere in the upper portion of the Query Designer. When
the popup menu appears, select Query Type, then Update Query.

3. In the Field: row in the first column found in the lower portion of the
Query Designer, select the field which is to be updated.

4. Now in the Update to: row for that first column, insert the value that
is to go into that field. Note: if the field to be updated is a Text
field, you must surround the value in double quotes; if the field to be
updated is a Number type, do not use quotes.

hth,

 

[Tim Ferguson]

it should be easy, but apparently i'm not doing something
right. I'm attempting to copy & paste data from row 1 to
the end of the table. I tried edit,append paste, but all
it does is add the text on the LAST record, and not the
other 70,000 rows.

This is not the sort of thing you should need to do in a database. If
something is there for all the records then it doesn't need to be stored at
all!

If there is some reason for updating all the rows, use an update query.

And logically there is no row 1 or last row... you won't see people here
talking about rows at all. Unless you specify a sort order, records will be
retrieved from the database in whatever order is convenient to the DBEngine
at the time, and is quite likely to change if you alter the data in the
records.

HTH


Tim F

 

[Guest]

I got it to work...all is fine now Thanks