Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 ! -- suki2shoes ------------------------------------------------------------------------ suki2shoes's Profile: http://www.excelforum.com/member.php...o&userid=25024 View this thread: http://www.excelforum.com/showthread...hreadid=385527 |
#2
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
my data truncates when ported from access to excel | Excel Worksheet Functions | |||
Microsoft Access Report into Excel Spreadsheet | Excel Discussion (Misc queries) | |||
How do I get an Access form in Excel to Expand the Data | Excel Discussion (Misc queries) | |||
Linking Excel to Access. | Excel Discussion (Misc queries) | |||
Managing an Access Database from Excel | Excel Discussion (Misc queries) |