I am looking for code or a component that will handle most of the different types of CSV files, like imbedded commas in a field.
Here are some of the conversions I have tried that did NOT work:
- .NET String.Split - will not handle imbedded commas
- OLEDB - sometimes thinks strings with numbers are numeric and removes leading zeros
- Lumneworks from CodeProject - exceptions too often and errors are difficult to understand
- FileHelpers - too much code to make it work
Thanks for any ideas