Delimiter

Last week while teaching a PowerPivot course I was asked if it was possible to import data into a Power Pivot table from text files with non-standard delimiters.

The answer is – YES!!

ODBC Desktop Text File Driver

PowerPivot uses the Microsoft ODBC Desktop Database Drivers.