Excel grid in Visual Studio 2005 app

31 Jan 2007 10:06 AM

Any User

Hello

I have an Excel spreadsheet, that holds some tabular data, and a macro,
that exports it daily do SQL Server 2000 table.

Now I want to build VS2005 application, that embeds Excel grid, that is
connected directly to SQL Server, so all editing will go directly to
database.

I've seen such application (unfortunately closed source), so I know,
that this is possible. But I don't know, how to start, since I'm a
DotNet beginner.

Can someone point me, where to start?

Thanks!

4 Feb 2007 3:18 PM

Alvin Bruney [MVP]

One of the better options is to use VSTO.

--
Regards,
Alvin Bruney
------------------------------------------------------
Shameless author plug
Excel Services for .NET is coming...
OWC Black book on Amazon and
www.lulu.com/owc

Show quote

"Any User" <zwy***@uzytkownik.pl> wrote in message
news:epppn6$1oh$1@opal.icpnet.pl...
> Hello
>
> I have an Excel spreadsheet, that holds some tabular data, and a macro,
> that exports it daily do SQL Server 2000 table.
>
> Now I want to build VS2005 application, that embeds Excel grid, that is
> connected directly to SQL Server, so all editing will go directly to
> database.
>
> I've seen such application (unfortunately closed source), so I know, that
> this is possible. But I don't know, how to start, since I'm a DotNet
> beginner.
>
> Can someone point me, where to start?
>
> Thanks!