Several times a week, I import a different text delimited table to process in Access, but it always takes me two steps because the text field parameter "Allow zero length" defaults to "No". I have to import once with errors, then change every field's parameter to "Yes", then delete all records, then import again into the existing table. I'm using MS Access 2000. Is they a way to change the default parameter value? Or is there a way to change all field's value quickly without having to click on each field.