Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Jul 2002
    Location
    North Dakota, USA
    Posts
    184
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Copy / Paste from Excel to New Access Table, Error (2000)

    A customer is getting the error shown below. Actually it's happening on all machines with Access 2000.

    These are the steps to reproduce the error. Open a new spreadsheet in Excel. type in some text in the cells, doesn't matter how many. Select the cells and Copy. then go to Access and in the table window click Paste button. You don't create a new table and then do paste, you just click the paste button. A message box appears asking does the first row contain headings, yes, no. You can click either one and get the error message before.

    The customer swears this worked without errors in Access 97. I tried it in Access 97 and it failed with an error of Couldn't find installable ISAM. I haven't tried it in Access 2002.

    Does anyone know if this is supposed to work in Access 2000? Or can get it to work in Access 97? (Not that that's an option for the customer.)

    Thanks.
    Sarah
    Attached Images Attached Images

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Copy / Paste from Excel to New Access Table, Error (2000)

    Others have this problem too - see <post#=277543>post 277543</post#>. I get the same error in Access 2002. No solution (except using other ways to import Excel data) has been proposed yet. <img src=/S/sorry.gif border=0 alt=sorry width=15 height=15>

  3. #3
    2 Star Lounger
    Join Date
    Jul 2002
    Location
    North Dakota, USA
    Posts
    184
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Copy / Paste from Excel to New Access Table, Error (2000)

    That's too bad.

    Has anyone found a MS knowledge base article that addresses the problem?

    Sarah

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Copy / Paste from Excel to New Access Table, Error (2000)

    I searched the Knowledge Base extensively and couldn't find anything about this. The question has been posted repeatedly in the Microsoft newsgroups, without a definitive solution.

Posting Permissions

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