There are a few things to watch out for on importing. (At least with MySQL, not
sure if
MSSQL has the same issues, but I would think so).
There are few characters that must be escaped:
NEWSTR=CHANGE(NEWSTR,"\","\\")
NEWSTR=CHANGE(NEWSTR,"%","\%")
NEWSTR=CHANGE(NEWSTR,"_","\_")
Also, I
On 17/08/10 05:47, Norman, David (Health) wrote:
> Thanks to all who responded. After managing to extract a bit more info from
> the user on what they think they might want, it now seems that all we need to
> do is put a CSV in a Samba share that can then be imported into MS SQL
> Server. Simpl