transfer data from and to excel [Resolved]

[haihems]

Hi All,

Actually i want to transfer the data to Excel from vb form and to show the data on vb form which comes from excel.

For that i 'm using the automation to conncet with excel. I can get and put the data to & from a single cell. But i want to access with huge data. What method shall i use for that?

I like to use DataGrid for showing the huge range of data. Can i use that?

Need the solution...Thanks in Advance.

[RobDog888]

If you have it or can get it, I suggest using VSTO. Its allot more
streamlined and simpler coding. No need for VB forms to handle
data. All can be done in VS.NET VSTO. Loading/Editing/Deleting of
records from a database directly in the spreadsheet, etc. Event
handeling and all kinds of new stuff. Check it out, great stuff!

[haihems]

Originally posted by RobDog888
If you have it or can get it, I suggest using VSTO. Its allot more
streamlined and simpler coding. No need for VB forms to handle
data. All can be done in VS.NET VSTO. Loading/Editing/Deleting of
records from a database directly in the spreadsheet, etc. Event
handeling and all kinds of new stuff. Check it out, great stuff!

Hai Robdog888,

I like to know more about vs.net VSTO. Where can I get the datails? Pls tell me..Thanks.

Bye..

[RobDog888]

Here is the link for - VSTO 2003

And the link for - VS 2005 Beta 1