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.
 
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

How to export table from outlook into ms access table? 0
import from ms access table name unknown 1
Excel 2003 Sheet 3
Access Importing csv daily files into access 2007 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Which is the best MBOX Converter Tool different formats conversion? 4
How can I migrate MBOX to PST? 2
How to Create a Macro to Import External Data 0

Back
Top