43179members
217428posts

Access Expert importing .CSV file SharingViolation_File Error

Access Expert importing .CSV file SharingViolation_File Error

Issue

Importing a .CSV file into Access Expert gives the following error:

Product Line

Access Expert

Environment

.CSV File

Cause

During the import the Excel doc holds the file open and causes a sharing violation in Access Expert.

Resolution

Close the Excel .CSV file during the import.

This will happen with the sample file from Access Expert or one created manually with the appropriate fields.

Tags (3)
Labels (1)
No ratings