#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2013
    Posts
    9
    Rep Power
    0

    Microsoft Access 2010 - Importing Data


    Thank you for your help!

    I have been called back to a client to help straighten out issues with an Access application that I developed for them last year.

    The project involves cataloging every product in a store, with particular attention paid to hazardous products for reporting purposes.

    They have an Excel spreadsheet with new/conflicting data for some of the products. I'd like to be able to merge the information into the existing database, with the new information overwriting anything that conflicts (conflicts are usually things like Hazardous Material Type). Is this even possible?

    Marcie Fessler
  2. #2
  3. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,280
    Rep Power
    4279
    Originally Posted by Marcieface
    Is this even possible?
    yup

    just import the spreadsheet into a new table, and use sql to compare and update your existing table
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

IMN logo majestic logo threadwatch logo seochat tools logo