How to transfer data from database to another database?

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!!

See help on TransferDatabase.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Jon" wrote in message
...
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!!

or

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

Pieter

"Allen Browne" skrev i melding
...
See help on TransferDatabase.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Jon" wrote in message
...
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!!

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

it's a wizard, takes no coding.




On Aug 9, 11:55*pm, Jon wrote:
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!!

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 @ g m a i l . c o" wrote:

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

it's a wizard, takes no coding.




On Aug 9, 11:55 pm, Jon wrote:
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!!

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



On Aug 10, 4:42*pm, Please Learn to Read
wrote:
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 @ g m a i l . c o" wrote:

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

it's a wizard, takes no coding.

On Aug 9, 11:55 pm, Jon wrote:
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!!

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

"a a r o n . k e m p f @ g m a i l . c o" wrote:

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