How can I add a field to a table automatically

[jeep2001]

I have a routine where I import a file (it will be daily).
I am using TransferText, which works fine. I manually add a field (Yes/NO) that the users check off...My question is ...how can I add this field automatically ...like right after the import happens.

 

[Golom]

CurrentDB.Execute "ALTER TABLE myTable ADD COLUMN FieldName BIT"

[small]No! No! You're not thinking ... you're only being logical.
- Neils Bohr[/small]

 

[jeep2001]

Thank you...That looks like it will do the trick.