Very Computer

Are there limitations to the size of data you can bcp into a table?
Each of the rows in this table is over 900 characters.

Thanks
Toni

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

--
Andrew J. Kelly   SQL MVP
Targitinteractive, Inc.

Quote:

> Are there limitations to the size of data you can bcp into a table?
> Each of the rows in this table is over 900 characters.

> Thanks
> Toni

> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

When creating the format file to be able to bcp the data into the table,
how would I tell it the field terminator at the end of the row is a
carriage return?  When I look at the formatting of the file in Word, it
just shows me the character.  I can't tell how to represent that via
text in order to put that into the format file.

Toni

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Hope this helps.

Dan Guzman
SQL Server MVP

-----------------------
SQL FAQ links (courtesy  Neil Pike):

http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
-----------------------

Quote:

> When creating the format file to be able to bcp the data into the
table,
> how would I tell it the field terminator at the end of the row is a
> carriage return?  When I look at the formatting of the file in Word,
it
> just shows me the character.  I can't tell how to represent that via
> text in order to put that into the format file.

> Toni

> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!