Closed GoogleCodeExporter closed 9 years ago
Do you have Excel 2010 installed on your computer?
Original comment by paulyo...@gmail.com
on 2 Jul 2011 at 1:59
[deleted comment]
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
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
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
@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
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
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
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
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
Original comment by paulyo...@gmail.com
on 5 Jul 2011 at 9:40
Original issue reported on code.google.com by
bshorr...@gmail.com
on 2 Jul 2011 at 5:56