Hi All,

I have a table with a Text data type field that I would like to change to a Double data type field programatically using VBA. I'm sure I've done this in the past using DAO and the TableDef object but can't remember how, does anyone have any example code ? Also, is there a way of doing it in ADODB as well??

Many Thanks