G Guest Feb 2, 2006 #2 The dOcMD IS: DoCmd.TransferDatabase acImport, "ODBC", "ODBC;DSN=FITS_TABLES;;TABLE=CAMAPROD.FSBLFILE", acTable, "CAMAPROD.FSBLFILE", "CAMAPROD_FSBLFILE", False
The dOcMD IS: DoCmd.TransferDatabase acImport, "ODBC", "ODBC;DSN=FITS_TABLES;;TABLE=CAMAPROD.FSBLFILE", acTable, "CAMAPROD.FSBLFILE", "CAMAPROD_FSBLFILE", False