Sql ændre fra text til number

Har en kode som opretter et felt i en tabel i min database fjern database). Hvis jeg nu skal ha' ændret et allerede oprettet felt som er felt type text til felt type number, kan det lade sig gøre, kan ikke rigtigt finde noget i min SQL-bog


Private Sub Command43_Click()
Dim dbs As Database

On Error GoTo Err_msg

Set dbs = OpenDatabase("c:\company shared folders\ShipToolDATA.mdb")


dbs.Execute "Alter table [MonthlyAccountTop] add  tekst1 text"
dbs.Execute "Alter table [MonthlyAccountTop] add  tekst2 text"
dbs.Execute "Alter table [MonthlyAccountTop] add  tekst3 text"
dbs.Execute "Alter table [Crew database] add medicinMemo memo"

Sub_exit:
    On Error Resume Next
   
    Set dbs = Nothing

MsgBox "New field added to ShipTool. After update open ShipTool and go to the setup form and fill in missing data.", vbInformation, "Update of ShipToolDATA completed "


    Exit Sub
   
Err_msg:

    If Err.Number = 3380 Then
        MsgBox "The field already exists, please press OK until you see 'Update of ShipToolDATA completed box' "
        Resume Next

    End If
   

End Sub