I've seen some online examples of how to do this but they require looping through each cell in the range and each record and field in the table. I.e...
Do While Len(Range("A" & r).Formula) > 0
' repeat until first empty cell in column A
.AddNew ' create a new record
' add values to each field in the record
.Fields("FieldName1") = Range("A" & r).Value
.Fields("FieldName2") = Range("B" & r).Value
.Fields("FieldNameN") = Range("C" & r).Value
' add more fields if necessary...
.Update ' stores the new record
r = r + 1 ' next row
I have a big, continuous block of data so this seems like a very slow way to do something really simple. Isn't there a way to do this without having to go through one cell at a time (i.e. transfer the entire range to a table)? Thanks!