Hi Everyone,
I have one xml file. There is lots of columns in that file. I have to insert SQL table. I did one query but i got error. How to do. Just tell the solution.
My Query is:
INSERT INTO #import (
XMLData
)
SELECT BulkColumn AS XMLData
FROM OPENROWSET (BULK 'C:\\Users\\lawrenced\\Desktop\\New Text Document.xml', SINGLE_BLOB) A
Error:
Cannot bulk load because the file "C:\\192.169.2.101\\Users\\lawrenced\\Desktop\\New Text Document.xml" could not be opened. Operating system error code 3(The system cannot find the path specified.).
Just tell the solution....
Thanks In Advanced. ...
Go to the complete details ...