Pass data between tables

[Rookie]

This is my scenario:
I develop a .asp app that reads its data from an Access DB "A", and I have a
desktop app with a FoxPro DB "B".

How can I insert data from a table in DB "A" to a table in DB "B". Im new to
asp and I really know only the basic's, so who can guide me to a tutorial or
where can I dowload an example... it would be great.

 

[Rookie]

O.K. thanks...
now I know what to do... but can you help me on "how to do it ?"
I searched the web, but cant find an example of how to do it....

 

[Rookie]

O.K. thanks...
now I know what to do... but can you help me on "how to do it ?"
I searched the web, but cant find an example of how to do it...

 

[Rookie]

O.K. thanks...
now I know what to do... but can you help me on "how to do it ?"
I searched the web, but cant find an example of how to do it...

 

[Rookie]

Im new in asp, and I dont know how to open more than one connection, and how
to "distinc" each one. I know that it should be something like this:

insert from db1.table1 field1, field2, field3 values db2.table1 field1,
field2, field3 where field1 = request.querystring("id_num")

This is my old code, it saves from a form to the database...
<%
'
' Open the database
'
set conn=server.createobject("adodb.connection")
conn.open("DBQ=" & server.mappath("Base.mdb") & _
";Driver={Microsoft Access Driver (*.mdb)};")
'
' user's information
'
v_name = request.form("name")
v_email = request.form("email")
v_age = request.form("age")
v_gender = request.form("gender")
v_comment = request.form("comment")
v_hideEmail = request.form("hideEmail")
'
' SQL INSERT query
'
conn.execute("insert into GuestBook " &_
"(name,email,hideEmail, age,gender,comment) " & _
"values (" & _
"'" & v_name & "'," & _
"'" & v_email & "'," & _
" " & v_hideEmail & " ," & _
" " & v_age & " ," & _
"'" & v_gender & "'," & _
"'" & v_comment & "')")
'
' Step 4: Close and exit the database
'
conn.close
set conn=nothing
%>

 

[Rookie]

Thanks to make me realize how "stupid" am I, I'm really new in asp, and "self
learning" is really hard,... Truth, I´m not a "great programmer" and was
expecting some help...

Thanks anyway...