Prev: File Name and Full Path Name
Next: routing slip in Excel 2007
From: Tom Sherwood on 28 Jan 2010 16:31
According to the Excel online help, the PivotCache.Connection property can be
set to "the path to and file name of a text file". I tried setting it to the
path and file name of a .csv file and it returned an error. Is there a way to
load a PivotCache directly from a flat file without having to load into a
spreadsheet or database? (The flat file has more than 1 million rows.)
--
Tom Sherwood
 | 
Pages: 1
Prev: File Name and Full Path Name
Next: routing slip in Excel 2007