Microsoft Access 2010

I have a customer table in Microsoft Access that has about 20,000 records.  From that 20,000 records I need just the records that match from a text file of about 200 accounts.  What is the best way to do this?  The customer account number would be the primary key between the Access database and the text file containing the 200 accounts.
grandrewAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
You should be able to Link to the Text file, which makes it looks just like an Access table.  Then create a query based on this example SQL:

PARAMETERS [Enter Value for Field1:] Text ( 255 ), [Enter Date:] DateTime;
SELECT Table1.*
FROM Table1 INNER JOIN Table2 ON Table1.ID = Table2.IDx;


mx
0
 
babesiaConnect With a Mentor Commented:
I would import text into table (eg tble200).

Then build query on these 2 tables.

SELECT tblAll.ACcounID, tblAll.*
FROM tblAll RIGHT JOIN tbl200 ON tblAll.AccounID = tbl200.AccountID;
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
See images for Linking drill ...

mx
Capture1.gif
Capture2.gif
Capture3.gif
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
TYPO ... my first post is the wrong SQL - from another question.

Corrected:

SELECT Table1.*
FROM Table1 INNER JOIN Table2 ON Table1.ID = Table2.IDx;

mx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.