I have an excel spreadsheet that I would like to be able to create every week and then import it into an existing table in Access. I created the spreadsheet and successfully imported it as a new table several times, however, when I would try to import the weekly additions I get an error. Of course it doesn't tell me what the error is it just says that there was an error importing. The weekly spreadsheet is in the same format as the original (i use a macro in excel to make sure it's EXACTLY the same). I didn't think the macro had anything to do with the error because I can still import to a new table, just not add to an existing one. Can someone help me please?