What I would do is this:
1) Import the first text file to an empty temporary table.
2) Run an append query to copy the data from the first table to the
permanent table. Include a calculated field in this query that provides the
value of "A" for all records.
3) Delete all records from the temporary table.
4) Import the second text file to the empty temporary table.
5) Run an append query to copy the data from the first table to the
permanent table. Include a calculated field in this query that provides the
value of "B" for all records.
6) Delete all records from the temporary table.

Signature
Ken Snell
<MS ACCESS MVP>
> Hello
>
[quoted text clipped - 12 lines]
>
> David
David - 28 Sep 2007 23:28 GMT
How do I do step 2?
I haven't used append queries before and I just don't know how to include a
calculated field.
> What I would do is this:
>
[quoted text clipped - 30 lines]
> >
> > David
David - 29 Sep 2007 00:06 GMT
I got it. Thanks a Bunch!
David
> What I would do is this:
>
[quoted text clipped - 30 lines]
> >
> > David