I am new to Access 2010, and I'm not a developer or advanced user. I know how to import external data (Excel, txt files, etc) to create new tables or append data to existing tables. I would like to make this a 'push-button'/menu type action using a macro. I have done this in the past in earlier versions of Access, but I can't find an appropriate 2010 macro action to assign to this task.
Any ideas?
Any ideas?