Hey, this coding seems to be just what I need.... apart from that I need to do it from Access! I've been going insane trying to find the coding to do this, but to be fair its been the end of a long day so that might be
I will be importing many spreadhsheets each month from Excel spreadsheets...