Tuesday, February 3, 2009

How to paste data from excel into an existing table in MS access 2007 without appending records

1. Export the table from access to excel
2. Update the records in excel
3. Create a form (datasheet) in access
4. Select the column(s) you have updated in excel
5. Select the column in the access form
6. Select paste special in access and paste as text

This retains updation in the order of the primary key and is fairly useful if you update based on excel sheets. Its usually better than  having a linked table.

No comments:

Post a Comment