Forcing OpenRowSet to read an Open file

  • 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.

  • No, sorry.

    CEWII

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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply