By powerpivotgeek (dwickert@microsoft.com), on April 27th, 2010
Question: By default PowerPivot has two limitations when working with text files (using the Office ACE OLE DB provider): (1) will only import data from files with an extension of .txt, .tab, and .csv; and (2) it will only recognize tab, comma, semicolon, space, colon, and vertical bar and column delimiters. Is there a way to change PowerPivot’s configuration so that it will recognize other file extensions or column delimiters?
0 Responses to “Howto: Get more flexibility when importing data from text files”