Access 2000 to access 97

[hcleo]

How can i tranfer some data from a access 2000 db to a access 97 db?

[pardede]

you could create an action query in the access2000 to put data in the access97 with an sql like

"insert into 97tablename in db97name
select * from 00tablename"

off course you can use a query instead of a table in the access2000

[JHausmann]

Would need to link the table first...

[Clunietp]

Or use two ADO connections, get a recordset from your A2K db, and execute INSERT SQL statements via your A97 connection....