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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Integrating information from Word to Excel (not mail merge) 1
Autonumber field in Excel that behaves the same as Access 0
Import Excel Column To Access with Criteria. Help 3
Excel - Wich Function should I use? 1
Importing excel spreadsheet into two tables at the same time 1
Merging from an Excel file with graphics 1
Embed the same Excel multiple times 0
Append Query or update query? 4

Top