akn112
08-30-2007, 06:16 AM
Hey all, im having problems with my transferdatabase method? I think it should be really simple but im banging my head on the wall to get it to work properly:banghead:
DoCmd.TransferDatabase acImport, "Microsoft Access", source, acTable, "tblCheckList", target
where source = "C:\source.mdb"
and target = "C:\target.mdb"
what i want it to do is import the table "tblCheckList" from source to target. but in the microsoft help file example
DoCmd.TransferDatabase acImport, "Microsoft Access", "C:\My Documents\NWSales.mdb", acReport, "NW Sales for April", "Corporate Sales for April"
there is no place to specify the target path, just the table name. need :help
thanks!
DoCmd.TransferDatabase acImport, "Microsoft Access", source, acTable, "tblCheckList", target
where source = "C:\source.mdb"
and target = "C:\target.mdb"
what i want it to do is import the table "tblCheckList" from source to target. but in the microsoft help file example
DoCmd.TransferDatabase acImport, "Microsoft Access", "C:\My Documents\NWSales.mdb", acReport, "NW Sales for April", "Corporate Sales for April"
there is no place to specify the target path, just the table name. need :help
thanks!