如何直接将word文档存储到sql数据库，使用ole能不能办到？如何处理？急！！

Question

如何直接将word文档存储到sql数据库，使用ole能不能办到？如何处理？急！！

Answer 1

http://expert.csdn.net/Expert/topic/1812/1812008.xml?temp=.5607569

Answer 2

adoquery.LoadFromFile但是sql里面应该是image格式.

Answer 3

copyfile(nfile,file,false);
TBlobField(TableLoad.FieldByName('word')).LoadFromFile(nfile);
试试，代码不全．就这个意思．

Answer 4

利用内存流
//save olecontainer to db
procedure TForm1.Button1Click(Sender: TObject);
var
  olestream:TMemorystream;
begin
  table1.Append;
  olestream:=TMemorystream.Create;
  olecontainer1.savetostream(olestream);
  olestream.position:=0;
  TBlobField(Table1.FieldByName('oledata')).LoadFromStream(olestream);
  Table1.Post;
  oleStream.Free;
end;
//load db to olecontainer
procedure TForm1.Button2Click(Sender: TObject);
var
  olestream:TMemorystream;
begin
  table1.Edit;
  OleContainer1.DestroyObject;
  olestream:=TMemorystream.Create;
  TBlobField(Table1.FieldByName('oledata')).SaveToStream(olestream);
  olestream.Position:=0; 
  OleContainer1.loadfromstream(olestream);
  oleStream.Free;
end;