Data for source column is too large for the specified buffer size...

Hello there,

I have and small excel file, which when I try to import into SQl
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 SQL Server and changed the
type of the field to text so I could accomodate this field but still
no luck.

Any suggestions as to how to go about this.

Thanks in advance,
Srikanth paispai@.immunetolerance.org (Pai) wrote in message news:<5332f465.0401101239.441dc621@.posting.google.com>...
> Hello there,
> I have and small excel file, which when I try to import into SQl
> 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 SQL Server and changed the
> type of the field to text so I could 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.|||PromisedOyster@.hotmail.com (Mystery Man) wrote in message news:<87c81238.0401111336.1216eb23@.posting.google.com>...
> spai@.immunetolerance.org (Pai) wrote in message news:<5332f465.0401101239.441dc621@.posting.google.com>...
> > Hello there,
> > I have and small excel file, which when I try to import into SQl
> > 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 SQL Server and changed the
> > type of the field to text so I could 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|||spai@.immunetolerance.org (Pai) wrote in message news:<5332f465.0401120742.d8bf3a4@.posting.google.com>...
> PromisedOyster@.hotmail.com (Mystery Man) wrote in message news:<87c81238.0401111336.1216eb23@.posting.google.com>...
> > spai@.immunetolerance.org (Pai) wrote in message news:<5332f465.0401101239.441dc621@.posting.google.com>...
> > > Hello there,
> > > > I have and small excel file, which when I try to import into SQl
> > > 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 SQL Server and changed the
> > > type of the field to text so I could 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.|||PromisedOyster@.hotmail.com (Mystery Man) wrote in message news:<87c81238.0401121321.7bae3a6e@.posting.google.com>...
> spai@.immunetolerance.org (Pai) wrote in message news:<5332f465.0401120742.d8bf3a4@.posting.google.com>...
> > PromisedOyster@.hotmail.com (Mystery Man) wrote in message news:<87c81238.0401111336.1216eb23@.posting.google.com>...
> > > spai@.immunetolerance.org (Pai) wrote in message news:<5332f465.0401101239.441dc621@.posting.google.com>...
> > > > Hello there,
> > > > > > I have and small excel file, which when I try to import into SQl
> > > > 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 SQL Server and changed the
> > > > type of the field to text so I could 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?

Thnaks,
Srikanth|||Pai wrote:
> PromisedOyster@.hotmail.com (Mystery Man) wrote in message
news:<87c81238.0401121321.7bae3a6e@.posting.google.com>...
> > spai@.immunetolerance.org (Pai) wrote in message
news:<5332f465.0401120742.d8bf3a4@.posting.google.com>...
> > > PromisedOyster@.hotmail.com (Mystery Man) wrote in message
news:<87c81238.0401111336.1216eb23@.posting.google.com>...
> > > > spai@.immunetolerance.org (Pai) wrote in message
news:<5332f465.0401101239.441dc621@.posting.google.com>...
> > > > > Hello there,
> > > > > > > > I have and small excel file, which when I try to import into
SQl
> > > > > 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 SQL Server and
changed the
> > > > > type of the field to text so I could 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?
> Thnaks,
> Srikanth

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