How to transfer data from database to another database?

[Jon]

Greeting,

I have db1 with table1 and db2 with the same table of db1. what I want to do
is transfer data from table 1 to table1 in db2. is there any way to do that
by using vb or sql but I want the code or sql to be in db1.

Thanks!!

 

[Allen Browne]

See help on TransferDatabase.

 

[Pieter Wijnen]

or

insert into table1 in 'c:\db2.mdb' select * from table1

Pieter

 

[a a r o n . k e m p f]

SQL Server has the ability to move data from A to B on a scheduled
basis

it's a wizard, takes no coding.

 

[Please Learn to Read]

Please learn to read. This might, or might not, be a good answer in an SQL
Server newsgroup; perhaps you could not understand that
"microsoft.public.access" is a newsgroup for Microsoft Access, not Microsoft
SQL Server. Basic literacy training is offered by local welfare and
educational organizations for the illiterate.

On the other hand, perhaps you received a divine revelation that the
question was not about the subject of the newsgroup, but about another
product entirely. If you have begun to receive divine revelations, that
should really worry and concern everyone here.

2008 Learn-to-Read Campaign

 

[a a r o n . k e m p f]

SQL Server is the most popular engine for Microsoft Accesss

Sorry that you still haven't seen the light; I don't need to be
bullied and stalked into stopping my helpful advice

 

[Please Learn to Read]

Most of the basic literacy courses also teach some elementary spelling. They
might cover that "Jet" is not spelled "SQL Server". Jet is, by a vast margin,
the most popular database engine for Access. After you have attained some
basic literacy skills, you might ask if they would assist you in
understanding the concept of "helpful advice" -- you have given none, so your
rant on that subject just does not apply. Please, please, seek help in
learning to read, as you obviously need the help they can give you... many
welfare and educational organizations offer basic "Learn to Read" courses to
the illiterate.

2008 Learn To Read Campaign