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.
"tzap_1998" wrote:
[Quoted Text] > 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
|