Prev: How rreliable is the CLSID method of obtaining a file location?
Next: Restore tray icon after Explorer restarts
From: mgcap on 8 Jul 2010 10:08
I am loading Excel with data and doing this in VB.net via SSIS.

I am using a command such as:

myWorkSheet.Range("A1").Resize(mydt2.Rows.Count, myColumnsCount).Value =
myArray4

The Array is already dimensioned correctly - 2 dimensional.

What I am seeing is that Resize is truncating any data that is over 255
characters in a cell.

Is there anyway around this and still being able to use Resize?

From: Jeff Johnson on 8 Jul 2010 11:51
"mgcap" <mgcap(a)discussions.microsoft.com> wrote in message
news:0C8784E3-D64C-4A0A-8CD2-614DBF1A732A(a)microsoft.com...

> I am loading Excel with data and doing this in VB.net via SSIS.

[Canned response]

This is a VB "classic" newsgroup. Questions about VB.NET (including VB
2005/2008 and VB Express, which have dropped .NET from their names) are
off-topic here.

Please ask .NET questions in newsgroups with "dotnet" in their names. The
*.vb.* groups are for VB6 and earlier.

For questions specific to the VB.NET language, use this group:

microsoft.public.dotnet.languages.vb

Please note that things like controls and data access, which have their own
subgroups in the Classic VB hierarchy, are not language-specific in .NET, so
you should look for groups like these:

microsoft.public.dotnet.framework.windowsforms.controls
microsoft.public.dotnet.framework.adonet

(Note that "vb" is not present in the group name.)


From: Paul Clement on 8 Jul 2010 11:59
On Thu, 8 Jul 2010 07:08:14 -0700, mgcap <mgcap(a)discussions.microsoft.com> wrote:

� I am loading Excel with data and doing this in VB.net via SSIS.
�
� I am using a command such as:
�
� myWorkSheet.Range("A1").Resize(mydt2.Rows.Count, myColumnsCount).Value =
� myArray4
�
� The Array is already dimensioned correctly - 2 dimensional.
�
� What I am seeing is that Resize is truncating any data that is over 255
� characters in a cell.
�
� Is there anyway around this and still being able to use Resize?

I would recommend posting your question to the Visual Basic (.NET) General web forum:

http://social.msdn.microsoft.com/Forums/en-US/vbgeneral/threads

AFAIK, the Visual Basic .NET newsgroups have been shut down.


Paul
~~~~
Microsoft MVP (Visual Basic)
From: Karl E. Peterson on 8 Jul 2010 14:33
Paul Clement presented the following explanation :
> AFAIK, the Visual Basic .NET newsgroups have been shut down.

Then you're not very well informed. I'm surprised you'd say that. 138
of them exist on this server alone!

--
..NET: It's About Trust!
http://vfred.mvps.org


From: DanS on 8 Jul 2010 14:51
Karl E. Peterson <karl(a)exmvps.org> wrote in
news:i155lo$e0s$1(a)news.eternal-september.org:

> Paul Clement presented the following explanation :
>> AFAIK, the Visual Basic .NET newsgroups have been shut
>> down.
>
> Then you're not very well informed.

Or has no understanding of how Usenet works.


> I'm surprised you'd
> say that. 138 of them exist on this server alone!
>

 |  Next  |  Last
Pages: 1 2 3
Prev: How rreliable is the CLSID method of obtaining a file location?
Next: Restore tray icon after Explorer restarts