SQL Alter Table Data Types 1

[surfbum3000]

I have a table that needs multiple column data types changed to text. I am using this code that works:

ALTER TABLE tbl6DaysSERVICES
ALTER ID text

The downside is I have to create a seperate query for each column to change each data type. I have tried:

ALTER TABLE tbl6DaysSERVICES
ALTER ID text, CLIENT_ID text, UNIT_ID text;

But this fails with a syntax error.

 

[sxschech]

From the Access Help Menu "Alter Table"

Notes

You cannot add or delete more than one field or index at a time.

 

[sxschech]

Perhaps you could set up the alter table in code with a variable and then loop through changing the value of each field? You could also try searching the forum for code to list the fields in your table and then you could use that to loop through a recordset to modify your alter table field for each item.

 

[surfbum3000]

Thanks.