Access Excel file without Excel

[djj55]

Is it possible to access an Excel file without installing Excel?

I am not the developer but just was courious as the developer says you do need to install. With my very limited experiance I had thought you could access a file without the install.

Specificaly, Excel 2010 from VB.Net 2008 (target .Net framework 3.5)

Thanks for your time,

djj
The Lord is my shepherd (Psalm 23) - I need someone to lead me!

 

[SkipVought]

Hi,

What do you mean by "access"?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[djj55]

By access I mean read the data in the file.

We recieve information from a "vendor" in spreadsheet form, which is read into a table.

We do not need to write to the file.


djj
The Lord is my shepherd (Psalm 23) - I need someone to lead me!

 

[gmmastros]

You can use OleDB to read from Excel. You may need to download and install the provider, but that part is free.

http://www.microsoft.com/download/en/details.aspx?id=13255

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[djj55]

George, If I had known you would answer I would have asked in the SQL forum.

I thought there should be a way to do it.

Thanks

djj
The Lord is my shepherd (Psalm 23) - I need someone to lead me!

 

[gmmastros]

I know.... I'm straying outside my comfort zone. Please don't tell anyone, it's a secret.

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom