Solved

Microsoft Access 2010

Posted on 2011-03-15
4
418 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 Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Dcount unique 6 22
Access MDB/PDF 21 32
Trying to develop input form for time clock database 15 23
Recording mileage on a form 2 11
When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

758 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

23 Experts available now in Live!

Get 1:1 Help Now