Hi Charlene,

I'm not sure what you mean by "a whole list of information". If these
are ordinary text files of data, try this:

1) Use File|Get External Data|Link to create a linked table connected to
the text file.

2) Create an ordinary Select query that gets its data from the linked
table and includes only the fields you need. If you only want some of
the rows from the linked table, set the appropriate criteria.

3) Once the Select query is selecting the data you need, turn it into an
Append query (by selecting Append Query... from the Query menu). Set it
to append its data to the table on which your Access form is based. For
each field in the query, select the appropriate field in the destination
table.

4) Run the query.

5) Delete the linked table.

If there's something unusual about the files, you'll need to explain it.

--
John Nurick [Microsoft Access MVP]

Please respond in the newsgroup and not by email.