MS Access 2010 - How to Create a Macro to Import External Data
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.