# How to add a field to an existing table using sql statement in MS Access

**URL:** <https://forum.kirupa.com/t/how-to-add-a-field-to-an-existing-table-using-sql-statement-in-ms-access/120048>\
**Category:** Uncategorized\
**Created:** [August 20, 2004, 6:14am UTC](https://forum.kirupa.com/t/how-to-add-a-field-to-an-existing-table-using-sql-statement-in-ms-access/120048 "2004-08-20T06:14:08Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![zyklone](https://avatars.discourse-cdn.com/v4/letter/z/e95f7d/32.png) [@zyklone](https://forum.kirupa.com/u/zyklone)\
**Post date:** [August 20, 2004, 6:14am UTC](https://forum.kirupa.com/t/how-to-add-a-field-to-an-existing-table-using-sql-statement-in-ms-access/120048/1 "2004-08-20T06:14:08Z")

</div>

[left][color=#003366]how to add a field to an existing table using **sql statement** in MS Access[/color][url=“[http://sdfsd](http://sdfsd)”]  
[/left]

---

<div class="post-metadata">

**Author:** ![amitgeorge](https://avatars.discourse-cdn.com/v4/letter/a/e5b9ba/32.png) [@amitgeorge](https://forum.kirupa.com/u/amitgeorge)\
**Post date:** [August 20, 2004, 8:15am UTC](https://forum.kirupa.com/t/how-to-add-a-field-to-an-existing-table-using-sql-statement-in-ms-access/120048/2 "2004-08-20T08:15:52Z")

</div>

ALTER TABLE \<\<tablename\>\> ADD COLUMN \<\<newfieldname\>\> TEXT(25);

see

[http://www.blueclaw-db.com/alter\_table\_ddl.htm](http://www.blueclaw-db.com/alter_table_ddl.htm)

for more info.