This is a discussion on Fulltext search on .doc files within the SQL Server forums, part of the Microsoft SQL Server category; --> Hello All, I am new to SQL Server 2000. I need to load a bunch of (*.doc) word documents ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Hello All, I am new to SQL Server 2000. I need to load a bunch of (*.doc) word documents into image fields to do full text searches on them. I created the doc_table (below) and tried to bulk insert one word document using the format file (far below) described in the books on-line. I get the error "Server: Msg 4829, Level 16, State 1, Line 1 Could not bulk insert. Error reading destination table column name for source column 1 in format file 'c:\bcp.fmt'." What am I doing Wrong? Thanks. CREATE TABLE [dbo].[doc_table] ( [doc_image] [image] NOT NULL , [doc_bind] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [doc_id] [int] NOT NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO ALTER TABLE [dbo].[doc_table] WITH NOCHECK ADD CONSTRAINT [PK_doc_table] PRIMARY KEY CLUSTERED ( [doc_id] ) ON [PRIMARY] GO ============================= bulk insert doc_table from 'c:\x.doc' WITH ( FORMATFILE = 'c:\bcp.fmt' ) ============================= bcp.fmt: 8.0 1 1 SQLIMAGE 0 5578 "" 1 doc_image |