Re: Long Records Giving me Grief!
- From: "Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx>
- Date: Sat, 14 Jun 2008 09:25:06 -0400
Siegfried Heintze wrote:
I fixed (kinda) my problem by truncating my records to 250 chars.
I'm automating the creation of my database and table definition using
VB Script.
When I use the UI I see there is another datatype called memo.
So this must be an Access (Jet) database? Are both the source and
destination databases Access?
However, when I look at
http://msdn.microsoft.com/en-us/library/ms675318(VS.85).aspx I don't
see such a datatype.
Right. It's an access-specific name. The corresponding JetSQL name is,
confusingly, "TEXT". The JetSQL name for the Access "Text" datatype is
"CHARACTER" ("CHAR" can also be used).
Will using type memo alleviate the 255 character constraint? How big
can memos be?
Up to 2.14 Gb
What is the number value for the constant adMemo -- I did not see it
at http://msdn.microsoft.com/en-us/library/ms675318(VS.85).aspx.
According to the handy datatype map put together by Carl Prothman
(http://www.carlprothman.net/Technology/DataTypeMapping/tabid/97/Default.aspx)
the ADO enum to use is either adLongVarChar or adLongVarWChar, depending on
your need to support unicode or not.
Could you provide a little more detail about what you are doing? Access has
builtin functionality for importing data from other databases. You might be
able to use an Access Application object to accomplish your objective much
more easily.
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
.
- Prev by Date: Re: Disconnecting and reconnecting record sets?
- Next by Date: Problems using ADODB and adPromptNever
- Previous by thread: Disconnecting and reconnecting record sets?
- Next by thread: Problems using ADODB and adPromptNever
- Index(es):
Relevant Pages
|
