[AccessD] selected table import from another backend

Hi John
Try something like

DoCmd.TransferDatabase acImport, "Microsoft Access", _
"C:\My Documents\SomedB.mdb", acTable, "TheNameOfTheSourceTable",
"WhatYouWantTheSourceTableToBeCalledInthisdB" 

Also where it says acTable you can insert
acForm if you want to import a form
acReport if you want to import a report

Also where it says acImport you can replace with acLink if you just wann link
rather than import
The import/link thing has its pros and cons

One Pro for linking is you always have the latest data (Assuming the linked
table is in some live and active dB)
One con for linking there may be (significant) speed issues, depending on
network, NICs,The dB setup, if it's a full moon etc etc
And of course vice versa 

See ya

Hope this helps

Darren

---------------------------------------
NIMBLE
T: 0424 696 433 


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Eget
Sent: Saturday, 17 December 2005 10:58 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] selected table import from another backend

Can anyone point me towerd a procedure that will import a table from a external
database?  I want to have an operator select a table titled tblPA from another
backend and eventually append a table after importing the table
 Thanks
John
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com