This probably has been asked but..... I want to copy certain columns from a tmp Table that I imported an Excel sheet to and put 2 columns our of many from it into an exsisting table in Access and put that data under already made columns. What would be the best syntax for this... I have tried as much as I can being pretty green with Access VBA syntax. Also for clarification I use Access 2000.