asked on
Import CSV file in Access
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.
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.
UI/UXMicrosoft Access
Last Comment
[ fanpages ]
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
[ https://www.experts-exchange.com/questions/29057671/SQL-for-Cascading-Combo-Box.html ]