There is probably an easy answer to this but...

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • FortyTwo
    New Member
    • Sep 2006
    • 1
    #1

    There is probably an easy answer to this but...

    I've been working on a database fr a while now, its for a low use online shop, I've got about 2600 records in an access mdb I use to get the info from, I have a primary Key set to the products sku and obviously a field that is the sell price, I've been trying to work out how to import a complete price update from an exl or another mdb which has only the sku and new price but I'm unable to do so.

    I basically need to import all the info from the new file, match it to the data in the main table and then update the prices. How is best to go about this?

    I'd like to also update a "discontinu ed" field if the price I added in was 0 for example. But this isnt essential as I can do that in the webpage code.

    Thanks for any help and sorry for the bad english, its late after another night of failed attempts to get it to work.
    Tags: None
    • tpawleska
      New Member
      • Sep 2006
      • 25
      #2
      It's easy to import the items just right click in the table area and go to import, but then you will need to select what tabel you want to import, if your access database is setup correctly this shoudl be easy if not, then you may need to alter either your database or your excell table to match up the tabs in excell with the tables in access.


      Originally posted by FortyTwo
      I've been working on a database fr a while now, its for a low use online shop, I've got about 2600 records in an access mdb I use to get the info from, I have a primary Key set to the products sku and obviously a field that is the sell price, I've been trying to work out how to import a complete price update from an exl or another mdb which has only the sku and new price but I'm unable to do so.

      I basically need to import all the info from the new file, match it to the data in the main table and then update the prices. How is best to go about this?

      I'd like to also update a "discontinu ed" field if the price I added in was 0 for example. But this isnt essential as I can do that in the webpage code.

      Thanks for any help and sorry for the bad english, its late after another night of failed attempts to get it to work.

        Comment

        Previous template Next
        Working...