Import a specific access table into new mdb

[AccessGuruCarl]

I'm trying to reduce the user from browsing for and selecting the table needed for importing.

I know the path, and table name. How can I code this in VBA so the the user just clicks the button and when the import finishes I just prompt a message. Instead of the user having to browse folders, select the mdb, and then the table.

Thanks...

AccessGuruCarl
Programmers helping programmers
you can't find a better site.

 

[deduct]

You need the

DoCmd.TransferDatabase

Karl

 

[AccessGuruCarl]

Thanks,

I found it shortly after posting.

Thanks Again.

AccessGuruCarl
Programmers helping programmers
you can't find a better site.