I've made that with for-loop and variables.
I don't have that example here, but it was something like this:
for i=0 to 10
RowNo() = $(i)
Insert into Example
You have to use Chr(39), you'll see:)