I am very new with Access so please be gentle if I'm committing a moral sin.
I extract info from a website that drops entries into an excel spreadsheet. I then take those entries and drop them into a table in Access. They typically map perfectly. Sometimes this website will had in random columns to the excel spreadsheet or update and have new, unneeded info slots. This screws up when I drop the info into Access (unless I notice the new columns in excel) and I need to redo.
Is there an easier way to do this? Should I be importing it differently in anyone's opinion? I know people say you should use a form (right?) but it really is much quick just dropping it into the table, but I would like to know if this is wrong