P
patriot301
I am trying to programatically create a pivot table with a tab delimited
data string. The fifth column of this string is the Value field with
numbers appearing in different formats or even text. I am creating this
pivot table by dropping the string on a sheet and using the Jet driver
to populate a record set which in turn populates the pivot cache. I
need to do it this way since I overshoot the 65000 row limit for Excel.
I can successfully create the pivot table if I eliminate all formats
and text values from column 5. I want to know if there is any way for a
pivot table to handle text based values and number formats.
Thanks.
data string. The fifth column of this string is the Value field with
numbers appearing in different formats or even text. I am creating this
pivot table by dropping the string on a sheet and using the Jet driver
to populate a record set which in turn populates the pivot cache. I
need to do it this way since I overshoot the 65000 row limit for Excel.
I can successfully create the pivot table if I eliminate all formats
and text values from column 5. I want to know if there is any way for a
pivot table to handle text based values and number formats.
Thanks.