DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: recordset to adox table.

  1. #1
    Drew Curry Guest

    recordset to adox table.

    After searching through the posts for "adox" it appears many folks are
    struggling with this. I find myself in the same boat.

    My problem:

    Take an ado recordset, pass it to a function along with a table name,
    and create a new table based on the fields in the rst. Seems simple
    enough. Fighting the field to column conversion issues.

    ADOX rears it ugly head and seems to make it very very hard. I am using
    an Access2k mdb, ado2.5, adox2.5. Has anyone worked out this generic
    routine and care to share some secrets.

    I am trying to take the results of:

    Set rst = cnn.OpenSchema(adSchemaProviderSpecific, , _
    JET_SCHEMA_USERROSTER)

    and push it to a table.... that is all..

    thanks, drew..

  2. #2
    Mike Guest

    Re: recordset to adox table.


    Drew:

    First, if you are using Access, you might want to consider using DAO. It
    is written specifically for JET. ADO actually might give you performance
    issues in a JET environment.

    Getting to your specific question, use a MAKE TABLE query following your
    SELECT. Do something like this:

    SELECT field1, ... , fieldn
    INTO tbl<TABLENAME>
    GROUP BY | HAVING | WHERE clauses

    This will work in DAO or ADO.

    Hopefully this answers your question

    Drew Curry <dcurry@no.spamola.home.com> wrote:
    >After searching through the posts for "adox" it appears many folks are
    >struggling with this. I find myself in the same boat.
    >
    >My problem:
    >
    >Take an ado recordset, pass it to a function along with a table name,
    >and create a new table based on the fields in the rst. Seems simple
    >enough. Fighting the field to column conversion issues.
    >
    >ADOX rears it ugly head and seems to make it very very hard. I am using


    >an Access2k mdb, ado2.5, adox2.5. Has anyone worked out this generic
    >routine and care to share some secrets.
    >
    >I am trying to take the results of:
    >
    >Set rst = cnn.OpenSchema(adSchemaProviderSpecific, , _
    > JET_SCHEMA_USERROSTER)
    >
    >and push it to a table.... that is all..
    >
    >thanks, drew..



  3. #3
    Drew Curry Guest

    Re: recordset to adox table.

    Because of the seemingly unusual nature of the rst returned by
    OpenSchema call, i resorted to created another regular adodb.recordset
    and filling that with the OpenSchema rst, assigned the new rst to the
    grid recordsource and everything is fine...

    drew..
    >
    > Drew:
    >
    > First, if you are using Access, you might want to consider using DAO. It
    > is written specifically for JET. ADO actually might give you performance
    > issues in a JET environment.
    >
    > Getting to your specific question, use a MAKE TABLE query following your
    > SELECT. Do something like this:
    >
    > SELECT field1, ... , fieldn
    > INTO tbl<TABLENAME>
    > GROUP BY | HAVING | WHERE clauses
    >
    > This will work in DAO or ADO.
    >
    > Hopefully this answers your question
    >
    > Drew Curry <dcurry@no.spamola.home.com> wrote:
    > >After searching through the posts for "adox" it appears many folks are
    > >struggling with this. I find myself in the same boat.
    > >
    > >My problem:
    > >
    > >Take an ado recordset, pass it to a function along with a table name,
    > >and create a new table based on the fields in the rst. Seems simple
    > >enough. Fighting the field to column conversion issues.
    > >
    > >ADOX rears it ugly head and seems to make it very very hard. I am using

    >
    > >an Access2k mdb, ado2.5, adox2.5. Has anyone worked out this generic
    > >routine and care to share some secrets.
    > >
    > >I am trying to take the results of:
    > >
    > >Set rst = cnn.OpenSchema(adSchemaProviderSpecific, , _
    > > JET_SCHEMA_USERROSTER)
    > >
    > >and push it to a table.... that is all..
    > >
    > >thanks, drew..

    >
    >


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center