Exporting data from SQL 2005 to Access

[bisjom]

Hi Guys,
I was trying to export the database from 2005 sql to access.
But it shows error
Setting Destination Connection (Error)
Messages
Error 0xc0204016: DTS.Pipeline: The "output column "ReplyText" (961)"
has a length that is not valid. The length must be between 0 and 4000.
(SQL Server Import and Export Wizard)

Exception from HRESULT: 0xC0204016
(Microsoft.SqlServer.DTSPipelineWrap)
I tried to change the size of the Reply text from varchar(500) to
varchar(50) and again it shows the message.
any idea?

thanks
Bismi
--
bisjom
------------------------------------------------------------------------
bisjom's Profile: http://www.dbtalk.net/m552
View this thread: http://www.dbtalk.net/t320367