HELP Copying Data from one table to another

[Bachfile]

Hello.

I've been working on an small museum artifact database and the main identifier of each object is the object's accession number. Before, this number was a long integer but it was later found that we needed more than the maximum number of figures that long integer would give. We selected the next one up - single, but that screwed everything up. It rounded all the accession numbers off for some screwed reason.

Is there any quick way to mass transfer new records from the table that is now screwed up to a backed-up table so I only have to go back and modify about 600 numbers instead of the whole database of 9000? I'm pretty new to this. These tables are essentially the same, just more data was entered into one of them. I can't seem to be able to select more than one record at a time - so I'm wondering if that is possible.

What I don't want to have to do is simply all of the new records in again by hand when they are essentially there, just the accession numbers are screwed up.

Any help that can be offered would be great!

Thanks for any help you guys can offer!

 

[amigeinraise]

In Datasheet View, instead of clicking on button at the left of the rows click on column header. This will highlight the entire column and if you right-click you'll find you can copy the entire column.

In order to paste the data you copied, click on the header of the column where you want the data to go and paste. The first row you copied, the column header, will not be pasted.

 

[Rich]

Change the field to double, or text