Accessing Excel, SQL and Access in C Charp

[bruce282]

I've written a dozen or so small apps that read and write data in Excel, SQK Server2005, and Access using objects. I'm not a wiz but I can usually make it work. Now I need to move these programs over to C# (I have the express in my machine but can get the Professional should I need it.

Before I spend hours trying to research this and end up getting frustrated.

Is there a compatible way to interface with these applications in C# ? If so might you point me to it.

Is there a book that goes into this that you're aware of? I stopped by the local Borders but damn they have bunches of books but since I'm not sure what I'm looking for it pointless to flip through the indexes.

Thanks ladies and gentlemen for the help.

Bruce
C# Rookie

 

[jmeckley]

Now I need to move these programs over to C# (I have the express in my machine but can get the Professional should I need it.

what language are they currently written in? This may effect if they *need* to be rewritten, or if you can simply reference the operation from another .net binary.

Jason Meckley
Programmer
Specialty Bakers, Inc.

faq855-7190
faq732-7259

 

[jmeckley]

another thought: C# is just a syntax for writing compiled object oriented code. knowing C# won't help you design good code. it will only help you know how to read/write C#. If you are interested in design quality code I would recommend:
books:
1. Domain Driven Design by Eric Evans
2. Most material related to the Gang of Four patterns (GoF)
3. Patterns of Enterprise Application Architecture
4. Head First Design Patterns (for entry level reference only)

Concepts:
Patterns, specifically the common GoF patterns.
S.O.L.I.D. design principles. the corner stone of quality code. here is a good primmer.

Websites (heavily emphasis on .net programming):

http://www.lostechies.com

http://www.codebetter.com

if you can understand this material, then it's just a matter of adjusting the syntax of a language: c#, java, vb.net, ruby, php, phyton, javascript, etc.

Jason Meckley
Programmer
Specialty Bakers, Inc.

faq855-7190
faq732-7259