c# LinqToExcel is not connecting to XLS in 64bit system but it is connecting xlsx file, tried DatabaseEngine.ace but didn't worked out.

[Member 11053420]

Code is string filepath = @"C:\\"+"k.xls"; string sheetName = "general_report"; var excelFile = new LinqToExcel.ExcelQueryFactory(filepath); excelFile.DatabaseEngine = DatabaseEngine.Ace;

[PIEBALDconsult]

Member 11053420 wrote:

@"C:\\"

Use either @ (verbatim string) or escape the backslash, not both. And why concatenate? string filepath = @"C:\k.xls"; ought to do it.

[Lost User]

Only works if the entire process is 64-bit. "Didn't work out", what does that mean? Did it throw an exception, did it explode?

Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]

[Raushank03]

To know your Better Solution please Visit on http://techgurulab.com/course/c-sharp-tutorial/