+ Reply to Thread
Results 1 to 2 of 2

excel comparing with access

  1. #1
    Registered User
    Join Date
    07-08-2005
    Posts
    5

    excel comparing with access

    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 !

  2. #2
    Dave O
    Guest

    Re: excel comparing with access

    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.


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1