excel comparing with access

  • Thread starter Thread starter suki2shoes
  • Start date Start date
S

suki2shoes

Hi

i have an excel spreadsheet with thousands of numbers, i have a
database of thousands of numbers also and i need to see which of the
numbers in the spreadsheet are in the database.

is this possible ?
please say if you dont understand what i'm trying to do, need to this
complete a project at work :)

thanks for any help !
 
You might find it easier to work backwards: instead of comparing Excel
to Access, compare the Access table to Excel. You can link an Excel
file to an Access database, and use wizards in Access to create "Find
Matched" and "Find Unmatched" queries.
 
You must log in or register to reply here.

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

excel spreadsheet compare 3
format cells as zip code not working 3
excel 2007 sorting issue with numbering scheme 1
Lookup? 2
Compare data in col A+B wih data in col C+D 5
Displaying zeros in cells 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
row locking, instead of file locking? 2

Back
Top