MySQL Forums
Forum List  »  Microsoft Access

Importing from Excel
Posted by: Simon Staton
Date: November 08, 2010 10:37AM


im not the best when it comes to excel and access however I was just wondering how I would go about doing the following:

Importing Product Prices to an Access Database from an Excel File

The Prices must overwrite those in Access from the given Product Ref

Basicly we have a shopping cart that reads off an access file, we also have a price sheet that we change all our prices on. is it possible to link these togther?

to give you an idea of the tables we are using here is an example:

Price Sheet:
Ref|||Name|||Price|||Competition Price

pad|||||prod desc||||||||50||||||25||||10

when we update the Price Sheet we want the access file to detect that product ref "10" has been changed and to then change that row in the database accordingly.

Thanks for any advice


Options: ReplyQuote

Written By
Importing from Excel
November 08, 2010 10:37AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.