Change Data Type of Table with VBA

[jeffsarah721]

I am trying to change the data type on an imported table from "Number" to "Text" using VBA or through a combination of SQL and VBA. The table is named EmployeesSales and the field that I want to change the data type for is called "Adi ID". I have searched all over the net and can't find any simple answers that apply directly to my situation. Can anyone help? Let me know if you need more info. Thanks!

Jeff Adams

 

[giacomo]

you can do this with SQL like this: ALTER TABLE [TABLE_NAME] ALTER [FIELD_NAME] text;

In VBA you could just execute the sql like this: currentDB.execute "ALTER TABLE [TABLE_NAME] ALTER [FIELD_NAME] text;"

hth,
Giacomo

 

[jeffsarah721]

Worked like a charm! Should have tried here to bgin with! Thanks!

Jeff