I need to automate the transfer of a table from one user's database to another's user's database. Can I write the commands into the canned transfer database (object) macro from the macro tab in Access? What do I need to insert? I want a point and click solution. Help!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Macro Help!
- Thread starter Caryisms
- Start date
tomschafer
Technical User
Do it with SQL.
select
*
into
Table
from
SomeTable
in
'c:\somedirectory\dbname.mdb';
select
*
into
Table
from
SomeTable
in
'c:\somedirectory\dbname.mdb';
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question