October 7th, 2013, 02:37 PM
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?
October 7th, 2013, 04:21 PM
Originally Posted by Marcieface
just import the spreadsheet into a new table, and use sql to compare and update your existing table