search

codeice / linqtoexcel

Automatically exported from code.google.com/p/linqtoexcel
0 stars 0 forks source link

Excel 2010 #48

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
can get info from Excel 2003 format, but can't get the same info from excel 
2010 format.

Is linqtoexcel not compatible with excel 2010 format?

Original issue reported on code.google.com by bshorr...@gmail.com on 2 Jul 2011 at 5:56

GoogleCodeExporter commented 8 years ago 
Do you have Excel 2010 installed on your computer?

Original comment by paulyo...@gmail.com on 2 Jul 2011 at 1:59

GoogleCodeExporter commented 8 years ago 
[deleted comment]
GoogleCodeExporter commented 8 years ago 
Yes i have Excel 2010 on my computer.
Does linqtoexcel require excel app?

Original comment by bshorr...@gmail.com on 2 Jul 2011 at 8:18

GoogleCodeExporter commented 8 years ago 
It requires the JET 4.0 database engine which is included when you install 
Excel or Microsoft Access. Depending on your operating system, it may already 
be installed.

You can download the latest version of Jet from here: 
http://www.microsoft.com/download/en/details.aspx?id=21373

Original comment by paulyo...@gmail.com on 4 Jul 2011 at 7:08

GoogleCodeExporter commented 8 years ago 
Thanks for the info. Can the engine work on the server without installing excel 
app. Or does it need to be on the client machine.

I still don't know if linqtoexcel should work with Excl 2010 format. In my case 
it doesn't, but it works with excel 2003.

Original comment by bshorr...@gmail.com on 5 Jul 2011 at 12:04

GoogleCodeExporter commented 8 years ago 
@up, you can do it other way. Just install "2007 Office System Driver: Data 
Connectivity Components", a set of drivers that transfer data between 2007 
Office files and other applications. 

Then you don't have to install any additional engine, nor Office on your server.

Just follow this link: 
http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=23734 , 
download and install on your server.

Regards, Lukas

Original comment by korzen...@gmail.com on 5 Jul 2011 at 5:23

GoogleCodeExporter commented 8 years ago 
Thanks Lukas.
Anyone knows if linqtoexcel should work with Excel 2010 files.

Original comment by bshorr...@gmail.com on 5 Jul 2011 at 5:30

GoogleCodeExporter commented 8 years ago 
Excel 2010 has many similarities with Excel 2007,such as the same native file 
format. Thus I don't think you should find any prblem with LinqToExcel while 
using Excel 2010.

Original comment by korzen...@gmail.com on 5 Jul 2011 at 5:35

GoogleCodeExporter commented 8 years ago 
I used the same code against excel 2003 and excel 2010 files. Was able to 
retieve data from excel 2003 file but not from excel 2010 file. I prefer to use 
the new format if possible. Any suggestion is appreciated.

Original comment by bshorr...@gmail.com on 5 Jul 2011 at 5:57

GoogleCodeExporter commented 8 years ago 
Excel 2003 files use the JET database engine where as Excel 2010 files use the 
ACE database engine. 

You will need to download the "2007 Office System Driver: Data Connectivity 
Components", a set of drivers that transfer data between 2007 Office files and 
other applications. 

Then you don't have to install any additional engine, nor Office on your server.

Just follow this link: 
http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=23734 , 
download and install on your server.

Original comment by paulyo...@gmail.com on 5 Jul 2011 at 7:20

GoogleCodeExporter commented 8 years ago

Original comment by paulyo...@gmail.com on 5 Jul 2011 at 9:40