I have VBA set to alter a field from an imported table from SharePoint. For some reason when I use the following code to modify the date type from Memo to Text
ALTER TABLE RAMP2015 ALTER COLUMN RAMP2015Company TEXT(50);
It produces the following error when I try to run a query against the table;
The setting your entered isn't valid for this property.
If I modify the data type manually I do not encounter the error. How can I adjust my code to make sure it works as if I am doing it manually?