Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003

    Unanswered: Get External Data "Type Mismatch" Error

    Whenever I try and Import from Excel I get a "type mismatch" error when ever I select the file. I don't even get to the wizard.

    Any suggestions?

  2. #2
    Join Date
    Dec 2002
    Préverenges, Switzerland
    import from Excel expects XLS (and there are some potential conflicts between recent XLS and the almost-Excel-97 access import filter).

    Excel can open .CSV etc without flinching.

    ...what is the file you are trying to open?

    Access can also open .CSV without flinching (and in most cases opens .CSV better than it opens .XLS).


    banging on a big drum - this is Micro$oft-warez: without version information in the question it is real tough to understand what is going on.
    currently using SS 2008R2

  3. #3
    Join Date
    Sep 2003
    I'm in access and I'm importing to a table.

    I tried saving the excel document as CSV and that didn't do it.

Posting Permissions

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