Error using CSV file

114 views
Skip to first unread message

M F

unread,
Jul 16, 2010, 4:57:52 PM7/16/10
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?

Paul Yoder

unread,
Jul 19, 2010, 8:24:47 AM7/19/10
to batmi...@gmail.com, linqt...@googlegroups.com
Can you send me the csv file you are using.
Reply all
Reply to author
Forward
0 new messages