Can anyone tell me how to create a command button to automatically import an excel file. The table and file location remain the same. I used to create a macro to perform this but cannot find it in Access 2010. I know how to "manually" import but this database is going to be for users that have limited knowledge and want to make it as painless as possible. There has got to be a way of automating this through a command button or something.
Thanks in advance for any help!
Thanks in advance for any help!