Forcing OpenRowSet to read an Open file

• Mushroom

  SSCrazy

  Points: 2226

  More actions

  March 2, 2010 at 7:44 pm

  #99110

  I am using OpenRowSet(bulk) as a view accessing a text file. If the text file is closed I am having no problems accessing the view and retrieving the data from the text file, however, if the file has been left open I get the following error messge.

  "Error Message: Cannot bulk load because the file 'Full Path & File Name' could not be opened. Operating system error code5(error not found)."

  Is there any way that I can force OpenRowSet to read the file ignoring the fact that it is open. I realise that if the file has been changed and not saved then I will not get those changes.

• Elliott Whitlow

  SSC Guru

  Points: 102402

  More actions

  March 2, 2010 at 8:00 pm

  #1127498

  No, sorry.

  CEWII

• Mushroom

  SSCrazy

  Points: 2226

  More actions

  March 4, 2010 at 6:05 pm

  #1128909

  Thanks for the response. I thought that would be the answer but was hoping that it wasn't.