Solved

Microsoft Access 2010

Posted on 2011-03-15
4
419 Views
Last Modified: 2012-05-11
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
Comment
Question by:grandrew
  • 3
4 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Access MVP) earned 250 total points
ID: 35142072
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
 
LVL 3

Assisted Solution

by:babesia
babesia earned 250 total points
ID: 35142134
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
 
LVL 75
ID: 35142148
See images for Linking drill ...

mx
Capture1.gif
Capture2.gif
Capture3.gif
0
 
LVL 75
ID: 35142160
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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now