The documentation you providee requires for the file to be present on the server side, not the client side, which is very dufferent from postgres.
As for BCP executable, i couldnt find a way for it to accept any type of date[time] at all
As for BCP executable, i couldnt find a way for it to accept any type of date[time] at all
That's one way, another was BCP.
But yeah if you are using python and loading row by row, or a large amount into a large table that has a clustered index, chances are that it'll be dead slow but that's expected.