Accessing Excel files - place data into SQL 2000 DB

[Guest]

I’m relatively new to .NET. I would like to write a VB.NET app (I read that using C# isn't as elegant when dealing with Office products) that reads in Excel files (forms) of both 2000 and 2003 versions, off a file system. I want to access the different cells, some fixed and some variable, and retrieve this data and input it into a SQL 2000 database. Can I do this using the Excel Object model within the VB.NET code? What are the implications to having some of these Excel files being of the version Excel 2000? Any info would be appreciated

Thank-you
Barb

 

[Cor]

Hi Barbera,

Have a look at this.

Office
http://support.microsoft.com/default.aspx?scid=kb;EN-US;311452

Pia Download
http://support.microsoft.com/default.aspx?scid=kb;EN-US;328912


I hope this helps a little bit?

Cor

I'm relatively new to .NET. I would like to write a VB.NET app (I read

that using C# isn't as elegant when dealing with Office products) that reads
in Excel files (forms) of both 2000 and 2003 versions, off a file system. I
want to access the different cells, some fixed and some variable, and
retrieve this data and input it into a SQL 2000 database. Can I do this
using the Excel Object model within the VB.NET code? What are the
implications to having some of these Excel files being of the version Excel
2000? Any info would be appreciated.