See the CopyFromRecordset function of the Range class.
Steve
On Thu, Dec 15, 2011 at 7:30 AM, lrantisi <lrant...@gmail.com> wrote:
>
> Instead of inserting data into single Excel cells using the statement:
>
> Activesheet.cell("A1").value = "Hello World 1"
> Activesheet.cell("A2").value = "Hello World 2"
> Activesheet.cell("A3").value = "Hello World 3"
> Activesheet.cell("A4").value = "Hello World 4"
> Activesheet.cell("A5").value = "Hello World 5"
>
> Can I use a single statement to insert a whole bunch of data in one
> statement.
>
> --
> You received this message because you are subscribed to the Google
> Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML
> Web Services,.NET Remoting" group.
> To post to this group, send email to dotnetdevelopment@googlegroups.com
> To unsubscribe from this group, send email to
> dotnetdevelopment+unsubscr...@googlegroups.com
> For more options, visit this group at
> http://groups.google.com/group/dotnetdevelopment?hl=en?hl=en
> or visit the group website at http://megasolutions.net
>
--
You received this message because you are subscribed to the Google
Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML
Web Services,.NET Remoting" group.
To post to this group, send email to dotnetdevelopment@googlegroups.com
To unsubscribe from this group, send email to
dotnetdevelopment+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/dotnetdevelopment?hl=en?hl=en
or visit the group website at http://megasolutions.net
