DataSet conversion to ADO Recordset

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

antonis74 - 29 Jul 2007 16:14 GMT

Hi,
I'm writing an application where the user creates a custom DataTable. How
can I convert it to an ADO Recordset, so to be able to save it to an Access
Database ? Or, is there any other way to directly save the DataTable as a new
Table in Access Database ?

Reply to this Message

Ralph - 29 Jul 2007 20:52 GMT

> Hi,
> I'm writing an application where the user creates a custom DataTable. How
> can I convert it to an ADO Recordset, so to be able to save it to an Access
> Database ? Or, is there any other way to directly save the DataTable as a new
> Table in Access Database ?

You used the term "DataSet" in your title...
This group is for Classic VB and classic ADO only. If this is for dotNet you
need to post to another newsgroup. One with "dotNet" in the title.

However, for VB all that is required to create your own recordset. Here is a
simple example...
' set a reference to ADO
Dim rs as ADODB.Recordset
Set rs = New ADODB.Recordset
rs.fields.append "Field1", adVarChar, 50
rs.fields.append "Field2", adInteger
rs.Open

Then fill it.
rs.Fields1.Value = "junk"
rs.Fields2.Value = 1
Then update/addnew and go on to the next one.

Reply to this Message

antonis74 - 31 Jul 2007 08:00 GMT

Indeed my problem is of .Net kind. Thanks for the response

> > Hi,
> > I'm writing an application where the user creates a custom DataTable. How
[quoted text clipped - 21 lines]
> rs.Fields2.Value = 1
> Then update/addnew and go on to the next one.

Reply to this Message

VB Forum / Database Access / July 2007

DataSet conversion to ADO Recordset