Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2005
    Posts
    29

    Unanswered: Import Errors - Ms Access2000

    I am having an error message whenever I tries to import an

    excel file into access table.I Am using MS Access import wizard.Fields names on the source

    file(excel) are exactly the same as on the access table but I

    am still having the same import error..."an error occured

    trying to import C:\Testimp.xls The file was not

    imported".......any idea of what could be wrong????
    Last edited by fadone; 11-28-05 at 02:41. Reason: REPHRASE

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    The error suggests that the data types are not the same. You may need to explicitly convert the columns.
    it can also happen if you have blank (or spaces in) cells in your excel spreadsheet which kids the import to believe the column contains text not numbers.

    HTH

  3. #3
    Join Date
    Nov 2005
    Posts
    29

    Solved

    Thanks....I have managed to import using DoCmd.Transferspreadsheet..... command.

Posting Permissions

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