you could write a short function to do it, but you may want to use the interface instead. maybe try a DDL query to add the fields first and import your text file to a new table, then append the recs using a dlookup. three steps, but that's not bad.
for a ddl query, try:
Code:
alter table YOURTABLE
add column YOURFIRSTFIELD text (255), YOURSECONDFIELD text (255)
for the final query, try:
Code:
update YOURTABLE set [new field 1] =
dlookup("new field 1 from import", "oldtable", "[commonfield] = '" & [commonfield] & "'"),
[new field 2] = dlookup("new field 2 from import", "oldtable", "[commonfield] = '" & [commonfield] & "'")