I have two text files that I would like to merge into one
based on a common data field. One has persons' names and
addresses, the other has different information about each
person. Both have a unique ID number that can be used to
combine the data. What is the best way to bring them
together? Using Excel? or Access? What process should I
use to get the text data into the program? then to combine
the data?

I'd appreciate whatever help anyone can give.

Thank you,

Jeanne

Import the data into two separate Access tables.
Create a new query using both tables as the data source.
Make the query a "Make Table" query to output the desired fields to a new
table.

Sal
www.ctgtrainig.com

"Jeanne" <sparkie@sparkie.us> wrote in message
news:055501c35169$d1144b90$a401280a@phx.gbl...