I am trying to add n columns to a table, like in this example of code where
n = 10:
Sub toto() Dim db As Database, i As Integer Set db = CurrentDb() For i = 1 To i = 10 db.Execute " ALTER TABLE time_series " _ & "ADD COLUMN F_" & i & " Number;" ' End If Next i End sub
I tried to convert
i in string with
CStr(i) but to no avail. Any hint?
EDIT: No column is added.