Showing contents of a directory in a list box (Excel file) and then selecting file to import

%3CLINGO-SUB%20id%3D%22lingo-sub-1084926%22%20slang%3D%22en-US%22%3EShowing%20contents%20of%20a%20directory%20in%20a%20list%20box%20(Excel%20file)%20and%20then%20selecting%20file%20to%20import%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1084926%22%20slang%3D%22en-US%22%3EDear%20All%2C%3CBR%20%2F%3EI%20have%20a%20little%20project%20at%20work.%3CBR%20%2F%3EAs%20you%20might%20have%20guessed%20what%20I%20am%20trying%20to%20achieve.%20So%20far%20I%20am%20able%20to%20show%20the%20contents%20of%20directory%20in%20the%20list%20box%20(in%20Access)%2C%20but%20I%20am%20not%20able%20to%20figure%20out%20how%20can%20I%20import%20excel%20file%20(data)%20into%20Access%20by%20choosing%20them%20and%20clicking%20a%20button.%20Any%20help%20will%20be%20much%20appreciated.%3CBR%20%2F%3ERegards.%3CBR%20%2F%3EAsad.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1084926%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E2010%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3E2013%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3E2016%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Contributor
Dear All,
I have a little project at work.
As you might have guessed what I am trying to achieve. So far I am able to show the contents of directory in the list box (in Access), but I am not able to figure out how can I import excel file (data) into Access by choosing them and clicking a button. Any help will be much appreciated.
Regards.
Asad.
0 Replies