Reading from .csv files about linqtoexcel

[paulyoder]

Sorry, I don't know of any configuration options that can be set. LinqToExcel uses OLEDB to read from the csv file, so I recommend searching for any configuration options available. And if you find one, let me know.

[nitewulf]

Found one.

I resurrected some old code I wrote using

http://msdn.microsoft.com/en-us/library/ms974559.aspx

I found that if I generated my schema.ini file using Format=Delimited (,) instead of Format=CSVDelimited OLEDB was able to read the .csv file without any issues.

From: Paul Yoder [mailto:[email protected]]
Sent: Friday, July 25, 2014 2:57 PM
To: paulyoder/LinqToExcel
Cc: nitewulf
Subject: Re: [LinqToExcel] Reading from .csv files (#49)

Sorry, I don't know of any configuration options that can be set. LinqToExcel uses OLEDB to read from the csv file, so I recommend searching for any configuration options available. And if you find one, let me know.

—
Reply to this email directly or view it on GitHub #49 (comment) . https://github.com/notifications/beacon/8270448__eyJzY29wZSI6Ik5ld3NpZXM6QmVhY29uIiwiZXhwaXJlcyI6MTcyMTkzNzQyNiwiZGF0YSI6eyJpZCI6MzgwMTM0MzF9fQ==--bc7d557626a77eaaaf90317b7f754106bc1530b8.gif

[paulyoder]

So it's working fine for you now?

[nitewulf]

sigh. No, it looks like I ran a test with the wrong file. I thought I had found a configuration option for OleDb to read my “special” .csv file. If I figure out some way to get OleDb to read the file I’ll let you know.

From: Paul Yoder [mailto:[email protected]]
Sent: Friday, July 25, 2014 4:22 PM
To: paulyoder/LinqToExcel
Cc: nitewulf
Subject: Re: [LinqToExcel] Reading from .csv files (#49)

So it's working fine for you now?

—
Reply to this email directly or view it on GitHub #49 (comment) . https://github.com/notifications/beacon/8270448__eyJzY29wZSI6Ik5ld3NpZXM6QmVhY29uIiwiZXhwaXJlcyI6MTcyMTk0MjUzNCwiZGF0YSI6eyJpZCI6MzgwMTM0MzF9fQ==--cdd997a61dc68f92ffb4c8ba474af3d75e75c0c7.gif

[usmanbinasif]

Hi,

Facing the same issue, is anyone found how to fix this ???

Regards,
UJ