Create a local cube with temporary data (without OLE-DB datasource)

[Ofri]

In my program I can query some data and want to aggregate them in a local cube to analyze them with OWC-Pivottable. I do not have an OLE-DB-driver to query the data, but I could preprocess them in some form (i.e. comma-separated). Is this possible? How do I write the "INSERT INTO"-statement

Thanks for help.