Import Table from Another Access DB

[bstice]

I am creating a macro and I am trying to get the macro to import a table from a parent DB to a local one. I know that someone will suggest linking, but my users don't usually have access to the network where the parent Db resides, so I have to have them import summarized tables.

I know that you can right click and select the import option, but that appears to be the only automated import option in access. I thought that one of the drop downs in the macro section would allow it, but it does not.

Specifically, I am trying to import a table named "MasterData" from a db named "PLbackend.mdb."

Is there way to do this using the macro tool or VBA? I am relatively new to access so I apologize if this is a really simple question. Thanks

Brennan

 

[Vassago]

Of course there is. No need to apologize, we were all new at one point. One of the hardest parts of Access is knowing EVERY function you may want to use.

Using a macro, you can use the command "TransferDatabase" to import/export/link any object between two databases. This should provide the actions you require. Make sure for the Database Name you put the full network path in case changes are made in drive mapping or users vary.

It also works in VBA, if that's your cup of tea.