Import Table

[depawl]

Not sure if this is the correct forum or not, but can some one help me out with vba code to import a table from another database?
On a form, I would like to have a command button, that when clicked on, imports a table from another database.
Just need some help with the code.
thanks

 

[ajetrumpet]

Use the interface for this. doing this with code is a huge waste of time, and it's hardly ever used.

 

[depawl]

sorry, but I am programming this for a user that will go berzerk if I try to tell her that she has to use the interface to accomplish this task. The only way I will ever get this one through is it she can do it with one mouse click. Or better yet, could the code be applied to the Open event of the form?

 

[ajetrumpet]

then you may need to hire a programmer.

 

[depawl]

With a bit of googling other forums I was able to figure out this code myself. I can post it if anyone is interested.

 

[marianne]

so what code did you find out?

 

[marianne]

docmd.TransferDatabase acImport ,"database type","database name",objecttype,"source file path","source file destination"

that code is one way of importing object from one db to another.

 

[depawl]

Yep, that's pretty much it.