Re: field DataTypes

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Aaron [SQL Server MVP] (ten.xoc_at_dnartreb.noraa)
Date: 10/28/04 

Date: Thu, 28 Oct 2004 10:36:32 -0400

Your column datatype choice is fine. The problem is your method. Try using
an INSERT statement in Query Analyzer, instead of the "paste" button within
Access. 

-- 
http://www.aspfaq.com/
(Reverse address to reply.)
"shank" <shank@tampabay.rr.com> wrote in message
news:#BjzNnPvEHA.1308@TK2MSFTNGP09.phx.gbl...
> I need a field that will hold a bunch of text.
> I tried TEXT and also NTEXT without success.
> I'm using MS Access as a front-end.
> Currently, I'm trying to paste 2000 rows and 140,000 characters.
> I know I will have more though.
> My  references say I should be able to hold 2GB+.
> I'm getting an error "the text is too long to be edited".
> What field type should I be using?
> thanks
>
>
Quantcast