I import flat text files with a schema.ini file for the properties of the files. I am using Microsoft.ACE.OLEDB.12.0 to import the files. We login as with windows user authentication.
The import command only works when user ABC is logged in. If I am logged in as any other windows user or even the SA Admin the import fails.
OLE DB provider "Microsoft.ACE.OLEDB.12.0"
for linked server "(null)" returned message "'c:\convdata\2265\' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.".
Msg 7303, Level 16, State 1, Line 7
Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0"
for linked server "(null)".
select * INTO [tablename1]
opendatasource('Microsoft.ACE.OLEDB.12.0','Data Source=c:\convdata\2265\;Extended Properties="Text;"')...FILE1#TXT