Easy Way to Import a Table?

[Hakala]

Hi, Tek-tips!

I'm building a database in Access 2002 which will have multiple non-tech users. Each month, a lookup table needs to be re-imported from the source database. This table has a name that changes, so I can't link.

What I would like to do is give the users a button to allow them to pick the table to import. (Clicking the button would do the same as choosing File|Import and finding and opening the source database.) I see the DoCmd.DoMenuItem code may do what I want but I don't know what parameters to give it.

Can anyone help?


Michelle Hakala

http://www.winebird.com/

 

[PHV]

You may try this:
DoCmd.RunCommand acCmdImport

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Hakala]

That's a great start! Is there a way to give it the path and database name?




Michelle Hakala

http://www.winebird.com/