Storing data into Access using VB

a1jit
11-13-2004, 04:28 AM
hI GUYS,

Normally i use this command to store data into database

adodc.Recordset.AddNew


It basically adds all the records into one particular table..

I was just wondering how do i add data into multiple tables

For and example, lets say i have 3 fields (Name, age and Gender)

I want Name and age to go into Personal table
I want Name and Gender to go into Personal1 table

How do i do that...i know how to write the sql command

For example

insert into Personal('Name','Age');

But how do i do using Visual Basic...The connection statements and all...

Is there any tutorial or anyone who can guide me through this

thankx in advance for any help

Timbo
11-13-2004, 10:00 AM
Have a look through the Database forum FAQ thread. You will need an ADO 'Connection' and a 'Command' object.
Post back if you get stuck :)

a1jit
11-14-2004, 04:02 AM
Yea..i was doing some reading on ADO 'Connection' and a 'Command' object

But i was just wondering whether is the any tutorial or someone who can roughly explain it to

Shurik12
11-14-2004, 04:18 AM
>is the any tutorial...

In the FAQ section mentioned by Timbo you can find one:Beginner's ADO Tutorial

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum