Hi,
If you try to connect to a excel non odbc driver using TDV it only takes .xls files but if you try to pull in .csv files it just do not support. This option should be available as .xls files have rows limit and it would be great if it supports .csv files too.
No Jason but thanks for letting me know will try that. In my current requirement we had to pull data from a shared drive so I thought Excel non odbc will work as source was csv but for now we changed it to excel format and it works fine.
Hi Alok,
Did you try our flat file adapter instead of the Excel non ODBC? That supports CSV files.
Jason