• Status: Solved
  • Priority: Low
  • Security: Public
  • Views: 82
  • Last Modified:

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.
1 Solution
yoducatiAuthor Commented:
Disregard.  I figured this out.  I have been staring at this for way too long.  I had some code that deletes the import if certain criteria aren't met after running some custom checks.  I had temporarily commented out the custom stuff I had in there but forgot to comment out the code that deletes the import.  It was importing correctly and then immediately deleting.  I hate it when I do dumb stuff.  I have it working now.
[ fanpages ]IT Services ConsultantCommented:
Perhaps you would like to revisit your open question now:

[ https://www.experts-exchange.com/questions/29057671/SQL-for-Cascading-Combo-Box.html ]
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now