Hi,
my first time doing an excel import. It works. Can close off when I
get to the last field with data, but would like it to keep checking to
see if there is any more data (user has a blank space between data
rows), not just exit
Have tried several things, but not sure how to get back to the top and
loop to the top until the last line is reached.
What I have so far is:
For i = i_from To i_to
i = i + 1
If (excel_ws.Cells(i, 2).Value = "") Then
***how to get back to the top???? (currently is
'goto close_excel' and saves data, exits)
Else
DoCmd.RunSQL "INSERT INTO ...
End If
Next i