Importing a Access Table

[ardy]

I am trying to import a table from another database. from all the stuff that I look at this code should work. but it just sits there as nothing happens am I missing something.....

DoCmd.TransferDatabase acImport, "Microsoft Access", _
 "Path_To_Database;PWD=password;LANGUAGE=us_english;", acTable, _
 "Source_Table", "Destination_Table"

Any help is appreciated.......:banghead: