View Single Post
  #1  
Old May 26th, 2010, 09:21 PM posted to microsoft.public.access
Simon
external usenet poster
 
Posts: 335
Default Update prices in access from Excell

I have a Spreadsheed with the follwoing Coloums, ProductCode, Price

I have a Access Table, tblProduct, with lots of flields but main ones
i need in this project are ProductCode and Price Inc VAt

Currently i have 1300 products in in the database, i have just been
given a spread sheet with 200 new prices for products already in
database. Is there a way to upload an excel spreadsheet that will
upodate price in access