I have several large Excel files (with the exact same fields) that I need to import into one table in Access 2007. I have been trying for hours with little success. I even tried converting them to .csv and nothing seems to work.
Let's say I have two .xlsx files that I wish to combine into...