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!

[RobDog888]

Sup Static! Long time no see. Hope everything is going well.

So you have the email contents auto importing to Access or ? Whats the logic?

[Static]

HEY!!!! Yeah it has been a while Things are good here.. how about with you??

Yes.. Access hooks to one email inbox, grabs each email, splits by vbcrlf, then loops through and does an insert (DoCmd.RunSQL("INSERT INTO blah blah") for each line... it works fine but I was wondering if there might be a better way to do this?


on a side note.. ever tried to import an XLSB file? it errors.... i have to convert to XLSX..