SQL Server, 对于指定的缓冲区大小而言，源列的数据太大

Hello there,

I have and small excel file, which when I try to import into
Server will give an error "Data for source column 4 is too large for
the specified buffer size"

I have four columns in the excel file, one of the column contains a
large chunk of data so I created a table in Server and changed the
type of the field to text so I accomodate this field but still
no luck.

Any suggestions as to how to go about this.

Thanks in advance,
Srikanth pai

----------------------------------------------------------------
How are you importing? bcp, dts or what?
We are currently using bcp to import text fields without any problems.
I have used also used dts for importing text fields in the past.

----------------------------------------------------------------
Hello there,

I am using DTS to import the excel file...

Thanks,
Srikanth Pai

----------------------------------------------------------------
Pai,

Some suggestions for you.

(1) Try using bcp.
(2) Try with a manually created file and see if you can work out the
differences between your sample file and the prblem file. It maybe
some data, eg quotes or control chars that are
(3) Send me email containing your schema and a sample data file
(cutdown to the 2meg hotmail limit) and I'll have a look.
----------------------------------------------------------------
Thanks promised one for everything, what I did here was saved the
excel file as a .txt file and then imported the file sucessfully, I
have never tried bcp?

----------------------------------------------------------------
FYI all, I had problems exporting to from Access. So by exporting
to text (from access) and then to using DTS...it worked!
==========================================

总结

以上是为你收集整理的全部内容。

如果觉得网站内容还不错，欢迎将推荐给好友。