Alter Column Type

[math20]

Hi,

I am trying to alter column type by using the following code:

DoCmd.RunSQL "ALTER TABLE DATA-SP-09 COLUMN AIR MILES Collector #/ Numéro d’adhérent AIR MILES TEXT"

It is giving me a syntax error, I believe it is because of the table name and column name which I can not modify is there any way I can still use this code to change the field type. There are more than one field/column type I have to change.

Thank you in advance for your help.

 

[lameid]

Use square brackets around field or table names that Access may have trouble interpreting...

Things that are keywords like NAME.
Things that are Delimeters like #, ", '
Things that are punction or syntax , ;
Things that contain white space like a space.

That's everything off the top of my head... but you are definitely in that realm. Also you can optionally use square brackets, so when in doubt, throw them int.

 

[math20]

Hi lameid,

It worked. Thank you so much.You are great. Have a Nice day!