Macro to import tables ...Please help

[tzap_1998]

I need a macro to import all tables in a database on my hard drive into
another database so I always have up to date information. The path name to
the database I need to import from is
c:\mitchell1\manager\series1\mdb\smcore32.mdb and I need to import all tables
into a database on my desktop called testinglink. I tried linking to it but
it would not let me. There is no "import" action in the macros window. Can
this be done with a script or a module? Any suggestions would be very
appreciated. I am blocked from linking to it which would be my first choice.

Thanks for any and all help

Tom

 

[Mike]

Try this, you will have to modify it to suit your purpose:
DoCmd.TransferDatabase acImport, "Microsoft Access",
"\\Rssms2-vopn1\Ms2-opndata\Public\Head Count\10 Hour Days\Monarch.mdb",
acTable, "Electrical", "Electrical"
Where "\\Rssms2-vopn1\Ms2-opndata\Public\Head Count\10 Hour
Days\Monarch.mdb" is the database you want to import from
and
the 1st "Electrical" is the name of the source table
and
the 2nd "Electrical" is the name of the table you want in your current table.
NOTE: if database is shared it is best to use the URL as I have.
Let me know if this works.