Change Data Type

[ryan1]

Does anybody know how to change the Data Type of a field in a table using VBA. Any help would be great.

 

[djeeten]

Currentdb.Execute _
"ALTER TABLE (table) " & _
"ALTER COLUMN (field) (type)", _
dbFailOnError

 

[ryan1]

"ALTER TABLE tblNewItem ALTER ITEM Number;"

Does this look right the table is tblNewItem
The field is Item
I want to change the data type from text to number.

Will this work.I keep getting syntax errors.

 

[djeeten]

Try this:

"ALTER TABLE tblNewItem ALTER Item Integer"

 

[djeeten]

I forgot column

"ALTER TABLE tblNewItem ALTER COLUMN Item Integer"

 

[ryan1]

I'm still getting syntax errors? If i change from alter to ADD Column it works, I'm stumped i've researched everywhere with no luck.