Importing table using vba

[at51178]

Hey Guys

I would like to create a button on my form where when I click on it
it will let me import a table from another database.

 

[celtc]

DoCmd.TransferDatabase acImport, "Microsoft Access", "H:\Access\MDB\Firefly Migrate.mdb", acTable, "JobComments", "JobComments", False

Look in TransferDatabase Method in help.

You'll need to build an interface where users can specify values to go above, or it will be limited to importing the same table from the sam db repeatedly.
Regardless of how you fill its arguments, this is the code that will do the business.
A good cheat is to create the macro, then get it converted into code.

TransferDatabase Method Example

The following example imports the NW Sales for April report from the Microsoft Access database NWSales.mdb into the Corporate Sales for April report in the current database:

DoCmd.TransferDatabase acImport, "Microsoft Access", _
"C:\DBS\NWSales.mdb", acReport, "NW Sales for April", _
"Corporate Sales for April"

 

[at51178]

Thanks for the response


Can it be set up that when I click on the button a window pops up and let me browse through my harddrive and pick the database just like the same way it is being done when you right click in the database.