access Button to download excel file into ms access 2007 table
Posted on 2011-03-02
I have a MS Access 2007 database where I need to give the user the ability to download an excel file of their choice (excel file could be located in multiple places but will always be formatted the same way) into an established table in my database. The field names of the access table match the column names of the excel file. Can anyone give me the code that the click event of the button needs to have to do this?
To be clear, when the user clicks the button, I'd like them to browse to the excel file and then, once the excel file is chosen, it would automatically be downloaded into the table, maybe with an "Are you sure?" prompt first. Is this possible? Thanks!