See if any of these options help:

Re: Picture Message #600012
and
http://doughennig.blogspot.com/2006/07/sqlxmlbulkload-rocks.html


>Hi,
>
>I have create a linkserver to read a vfp file with a photo field, the name and file STRUCTURE of vfp as follows:-
>
>/*
>ITEMPHOTO TABLE STRUCTURE
> VFP: (ITEM_NO CHAR(10),ITEMPHOTO GENERAL)
> SQL: (ITEM_NO CHAR(10),ITEMPHOTO IMAGE)
>*/
>
>The link server as follows:-
>
>--EXEC SP_ADDLINKEDSERVER
>-- @SERVER = N'FOX2', -- YOUR LINKED SERVER NAME HERE
>-- @SRVPRODUCT=N'VISUAL FOXPRO 9', -- CAN BE ANYTHING
>-- @PROVIDER=N'VFPOLEDB',
>-- @DATASRC=N'"C:\BTM\123\DATA1.DBC"'
>--EXEC SP_ADDLINKEDSRVLOGIN 'FOX2'
>
>After the server is created i checked to read the file without the photo field it is he read the file with no error, but with the photo field i have the below error :-
>
>SELECT item_no,photo FROM OPENQUERY(FOXPRO,'SELECT item_no,photo FROM ITEMPHOTO')
>the error message as follows:-
>
>Msg 7399, Level 16, State 1, Line 1
>The OLE DB provider "VFPOLEDB" for linked server "FOXPRO" reported an error. The provider ran out of memory.
>Msg 7330, Level 16, State 2, Line 1
>Cannot fetch a row from OLE DB provider "VFPOLEDB" for linked server "FOXPRO".
>
>
>best regards