TransferDatabase command not working

[marathonlady]

I need to import tables to an access db and am trying to automate it. My transferdatabase do cmd appears to run since Ii have error traps in the code and the errors are never output,
but the transfer is unsuccessful and the table is not imported.

What could I be doing wrong?

Thanks

 

[jfgambit]

Can you post your code?

 

[marathonlady]

Here's my code:

DoCmd.TransferDatabase acImport, "Microsoft Access", "D:\" & strMDBName, acTable, "CLR Extract Time", "New CLR Extract"

 

[jfgambit]

hmmmm....looks ok...

Have you tried testing the full path by taking out strMDBName and replacing it with "D:\nameofforlder\etc."? Maybe you are missing something in the strMDBName (the file extention maybe).