M F
unread,Jul 16, 2010, 4:57:52 PM7/16/10Sign in to reply to author
Sign in to forward
You do not have permission to delete messages in this group
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to Linq To Excel
Hi,
I am trying to use LinqToExcel to query a CSV file like in the example
on the wiki. Here is the code I am using:
var csv = new ExcelQueryFactory(filePath);
var csvEmps = (from e in csv.Worksheet()
select e).ToList();
Every time it gets to the linq query, this exception is thrown:
System.Data.OleDb.OleDbException: The Microsoft Jet database engine
could not find the object '<name of file>'. Make sure the object
exists and that you spell its name and the path name correctly.
It seems to be a problem with csv files, because when I query an XLS
file from the same folder, no error is thrown.
Any suggestions?