<div>
Perhaps you would like to revisit your open question now:<br />
<br />
[ <a href="https://www.experts-exchange.com/questions/29057671/SQL-for-Cascading-Combo-Box.html" rel="ugc">https://www.experts-exchange.com/questions/29057671/SQL-for-Cascading-Combo-Box.html</a>&nbsp;]
</div>


Perhaps you would like to revisit your open question now:

[ https://www.experts-exchange.com/questions/29057671/SQL-for-Cascading-Combo-Box.html [https://www.experts-exchange.com/questions/29057671/SQL-for-Cascading-Combo-Box.html] ]

<div>
<div class="content wysiwyg-content">
I need to be able to import a csv file into an access table while allowing the user to browse to the file. &nbsp;I have a file picker dialog process that allows the user to do so and although the process runs without any error messages, no data is imported. &nbsp;<br />
<br />
I am aware of how to create an import specification and running the saved import from the external data tab works, but I need to be able to run this from the user interface and the file path will not always be the same, nor will the file name.
</div>
</div>


I need to be able to import a csv file into an access table while allowing the user to browse to the file.  I have a file picker dialog process that allows the user to do so and although the process runs without any error messages, no data is imported.  

I am aware of how to create an import specification and running the saved import from the external data tab works, but I need to be able to run this from the user interface and the file path will not always be the same, nor will the file name.

Import CSV file in Access

UI stands for User Interface and UX for User Experience. While there are key differences between the two, both concern the design of how humans interact with computer systems and software.

UI/UX

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.