[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 430
  • Last Modified:

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.
0
grandrew
Asked:
grandrew
  • 3
2 Solutions
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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
 
babesiaCommented:
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 MVP, Access and Data Platform)Commented:
See images for Linking drill ...

mx
Capture1.gif
Capture2.gif
Capture3.gif
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now