ADO table from a recordset

Hi, I know this is the same question over and over.

Let's do it once more: I have an ADO recordset. I want to make it a
permanent table in Access. I can create an Access table with ADOX and
go through the whole ADO recordset, record by record, add them to the
newly created Access table, one by one.

There must be a better way, for crying out loud! even in Excel you can
use Range("A1").copyfromrecordset(myrecordset) and its done!

I´ve read a lot of shortcuts like, "if you are creating the recorset
from a SQL server table (for example) instead of trying to create a
table from that recordset, link the table and then run a make-table
query in access"

that´s a good idea. However in my case, the recorset comes from a MDX
query, in other words, I am trying to create a table from a query that
is a view of an OLAP cube.

There is a Knowledege Base article about it (Convert ADO MD cellset to
ADO recordset).

Now, I want this ADO recordset as a table in Access.

As far as I´ve read in this forum, there is no way to do it easily,
and there is no possibility of linking it directly as a linked table,
since the source is an OLAP cube...

any comments

Thanks

Alvaro

.

Relevant Pages

  • RE: Find all records that match attributes of current part number
    ... I have the two queries made that I talked about in ... I've varied adcmdtable, adlock, adopen and I always get an Error ... When I run the query by itself it works fine. ... how do I get the results of a select query into an ADO recordset so ...
    (microsoft.public.access.queries)
  • Extracting Data from SAP BW
    ... I'm attempting to extract data from SAP/BW using OleDB for OLAP and an ADO recordset. ... I'm connected to the BW server and getting some data back but am having trouble getting the query to work exactly like I want it to. ... I can get the basic informationdown but am having trouble getting the data to display like I would like it to. ...
    (microsoft.public.data.ado)
  • Re: ADO to get Access query results
    ... Public Sub TestSub() ... >I have a database with a select query already defined using the QBE grid. ... > get the results of the "top level" select query into an ADO recordset. ...
    (microsoft.public.data.ado)
  • Re: ADO table from a recordset
    ... "if you are creating the recorset ... from a SQL server table instead of trying to create a ... query in access" ... I have an ADO recordset. ...
    (microsoft.public.data.ado)
  • Re: Creating ADO recordset of totals qry
    ... > I use the following code to open an ADO recordset of a totals query. ... > I then try to take the total for field TotA and put it into a ... I know the value does exist in the query. ...
    (microsoft.public.access.formscoding)