Dear AccessNub,
I'm using your function and it works as far as the importing & moving goes, but gives an error on the Error Handle (how ironic ;))
Error_Handle:
CurrentDb.Execute "DELETE testingBeatport.*, testingBeatport.ImportDate FROM testingBeatport" & _
"WHERE...