paste inquiry: easy one!

[novicehacker]

i imported data from excel into access, the problem is i forget to create one extra field, now in access i've created another column for this field but i want to paste the data quickly without having to do a cut and paste operation every time, can i just select this data and paste it, or do i have to past individually.

To illustrate i have 9000 records for different vehicles, each record has fields of user date used, duration, date returned etc. Now to each record i want to add the vehicle ID, how can i do this quickly without having to cut and paste the ID no. many times?

Can i create a macro in access i don't know how, and can i drag the vehicle id no. from one celll to the next like i can in excel.
Your help would be appreciated!!

 

[bat17]

A lot depends on what you have! If the data all comes from a table in Excel and you have not changed the order of the records in Access you can copy the data in the column in Excel then highlight the column in the Access table (by clicking it field name) and paste the data directly into it.

HTH

Peter

 

[novicehacker]

Thanks a lot for the tip , Bat, i've been dragging, pasting for ages, i think this should do the trick. Thanks once again.