• I've been trying to use BULK INSERT but I'm getting this error (which I'm in the process of trying to solve)

    Cannot bulk load because the file "C:\users\xxx" could not be opened. Operating system error code 5(Access is denied.).

    The text files I'm trying to import are of various lengths split by pipes (|) but I wish for the data to not be changed (still want pipes included, no delimiting at all) so I only have one column in my table called 'Data' (varchax(MAX)) that I am dumping it into.

    The trouble I'm having with the code on the link is that it delimits the data which I do not wish to do but I can't work out which bit to take out to stop it from delimiting, as I don't fully understand the code. It would work perfectly for what I want though, so I'd like to stick with it if possible.