importing to access from excell

[Guest]

Hi
I have a large database in access approx 180.000 items and would like to add
barcodes to each i have created a new column and have the barcodes of 30.000
items in and excell folder these can be matched using the primary key but i
would like to import them into access so all is in one database - any ideas

 

[Guest]

You could try linking to the Excel file and write an update query that would
join the excel file with your access table and update the barcode field in
Access.