New user-import & query question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to import 2 excel tables (I already know how to save them in the
correct format) into Access then create a query to find the codes that do not
match.
I can't get both tables to import in and I can't figure out how to create
this simple query.
 
Your stating that you "already know how to save them in the correct format"
begs the question, "In what format did you save them?" because Access can
import an Excel .xls file! Can you get either file to import? Do you mean
that you don't know how to import the files or that when you attempt to imort
them the procedure fails?

When and if you do get these two files into Access tables, when you select
New in the queries window, you will see a choice that says Find unmatched...
Use this and follow the wizard through.
 
Back
Top