I've search the forum for historical thread successfully, but none of the solutions have worked for me. Depending on the approach I take, I get one of several common errors, including:
1) The most common ....."The external table is not in the expected format...", via:
DoCmd.TransferDatabase...