method Pivot.AppendData ([Source as Variant], [Options as Variant])
Appends data to the control (prevents clearing data already loaded).

TypeDescription
Source as Variant Indicates the data to append as one of the following:
  • ADO.Recordset, ADODB.Recordset or DAO recordset (similar with DataSource, Options parameter has no effect) 
  • An indicator of the object that specifies the source for the XML document. The object can represent a file name, a URL, an IStream, a SAFEARRAY, or an IXMLDOMDocument (similar with LoadXML, Options parameter has no effect) 
  • A String expression that indicates the path to a CSV file to be loaded or the content itself (If the expression points to a file, the file's content is loaded) (similar with Import, Options parameter specifies different options to be used when loading data using the Import method as explained bellow.)
  • a Safe Array one-dimension or two dimensional to be loaded. If the Source parameter points to a one-dimension safe array, it indicates the rows to be loaded. If the Source parameter refers a two-dimension safe array, the first dimension indicates the rows, while the second indicates the column. If the Options parameter includes the word "reverse", the first dimension indicates the columns, while the second indicates the rows of data (similar with Import, Options parameter specifies different options to be used when loading data using the Import method as explained bellow.)
Options as Variant A String expression that specifies different options to be used when loading data using the Import method as explained bellow (similar with Import).
ReturnDescription
VariantReserved for future use only.
The AppendData(Source, Options, Result) method appends data to the control. the AppendData method does not clear the data already loaded into the control. The AppendData method can add a new data source (ADO or DAO recordset), XML file (previously saved by SaveXML method) or anything that Import method accept. The ClearData method clears the control's data. You can use the Layout property to store the control's layout and to restore the layout later.

The control can load data using one of the following methods: