Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2002
    Posts
    9

    Cool Unanswered: Copying data from Excel 2000 to MS Access 2000

    Hi,
    I usually import from files however I occasionally paste data from excel, straight into a MS Access table this seems to be very hit and miss.

    I usually get this error message :

    'The Microsoft Jet database engine could not find the object <Cell References>. Make sure the object exists and you spell its name and the path name correctly'

    Anyone else experienced anything similiar ? or know why this could occur ?



    Thanks
    Rob W

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    only guessing, but see if in Excel: select-all, copy, paste-special(values) fixes the problem.

    izy

  3. #3
    Join Date
    Nov 2002
    Posts
    6
    In Access instead of using paste, use paste append in the edit menu.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •