Overview
If you are trying to import data, you may be seeing an error message similar to below:
Orchestrate Data Flow Import has failed. The detailed information is as follows:
ERROR [HY000] [Microsoft][ODBC Text Driver] The Microsoft Jet database engine cannot open the file (unknown). It is already opened exclusively by another user, or you need permission to view its data.
Import Command:-
SELECT DISTINCT STITEM05 As ItemCode
,STITEM05 As ItemDescription
,1 AS MfgBatchSize
,Blend as ProcessCode
,Kg As UnitCode
,LEFT(STITEM05,1) As ItemTypeCode
FROM [NAME OF FILE.CSV]
What is causing this, and how do I fix it?
The CSV file is already open from the network drive by another colleague. Close the CSV file and the data import will continue to run and complete.