"INSERT INTO" IN Same Table different database

[meravsha]

How can i insert data between similar Access tables in different database?
in sql Server this option exist because there is One connction. like:
"INSERT INTO dbo.Database1.Table1
SELECT * FROM dbo.Database2.Table1"

but how can i Write it with Access database in VB6 ?
Does ADO has object name Table?

 

[manishjoisar]

INSERT INTO TABLE IN [File Name With Path]
Select * From TABLE