troubleshooting Question

Import CSV file in Access

Avatar of yoducati
yoducati asked on
UI/UXMicrosoft Access
2 Comments1 Solution168 ViewsLast Modified:
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.
ASKER CERTIFIED SOLUTION
yoducati

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros