importing to access from excell

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
Back
Top