compare excel cell to access field

[yoonie_85]

Hey...

i'm wondering if anybody could help me with this as it is kind of urgent...

does anybody know how to compare a cell value in excel to a field in access?

I have to compare each cell in the 2nd column of Excel to the 1st field in access. and if they are equal then copy and paste that specific row to a new table in access.

i have no idea where to begin...

thanks in advance

 

[Pat Hartman]

Link the spreadsheet to your db. Write an append query that joins your access table to the linked spreadsheet. Join the first table column to the second spreadsheet column. Select the columns you want to append.