Access INSERT 1000's of rows from Email - best method?

[Static]

Hi!

I have a daily email... it has anywhere from 500 to 3000+ lines that need to be scanned into a table (they are huge file names)

currently doing in a simple loop.. I split the email body by vbCrLf then loop the lines,
if the line has certain text instr() then i insert

DoCmd.RunSQL("INSERT INTO blah blah")

so essentially it has to do a ton of inserts..

is there a better way of doing the insert?

thanks!