>Eric,
>
>Does this code ADD a new column, or change an existing column?
>
>Thanks
You can delete the existing column using
cat.Tables("Table1").Columns.Delete "fldDecimal"
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com