I get monthly dealer sales reports in an excel spread sheet. I clean them up for import into Access. I want to import them into 1 complete table every month so I have a accumulating sales table for all the dealers. Not every dealer has sales every month so the record count could be different. I have tried importing each spread sheet but I cannot get the months to go into their respective columns. I could create a table with all the dealer names and add in the monthly sales manually, but I would like to do something that is faster and much more accurate.