Importing Excel file into Access or a database

N

Nathan

Hello can someone help?
I want to Query a excel spreadsheet, which then checks the database to see
if its the same price or it exists if its different price i want
it to update it?

I can do that manually the first time but after that I want the
database 2 query the new spreadsheet for price updates.
 
J

Joe Fallon

There is no simple answer to this.
I would import the spreadsheet and write queries to figure it out.
Perhaps some code too.
 
Top