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

    IMPORT ERROR ..PLEASE HELP

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



    excel file into access table.For importing,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????

  2. #2
    Join Date
    Dec 2005
    Location
    Wilmington, DE - USA
    Posts
    275
    It could be that your Excel worksheet is not set up properly. For example, do you have any blank columns or rows in the import range? Do you cells that are evaluating to error values in Excel? Are you mixing data types in your columns?

  3. #3
    Sinatra Fan is offline Novice
    Windows 10 Office 365
    Join Date
    Apr 2006
    Location
    Orlando, FL
    Posts
    8
    I don't mean to hijack this thread, but I am having the same issue.

    I originally imported my master list of data (currently in an excel file) into a NEW access table. That worked fine. Then I proceeded to make minor changes to the table. Things like adding descriptions, reducing the field size, adding caption names and such.

    Now, I tried to import ADDITIONAL data into the existing table and got the same error message that fadone is getting. I should add that the field names in the access table are still exactly the same as the ones I am importing.

    So I ask, what's the problem?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Import Wizard Not Working
    By cjh2001 in forum Import/Export Data
    Replies: 1
    Last Post: 01-24-2008, 06:33 PM
  2. Import large txt into access
    By klm127 in forum Import/Export Data
    Replies: 0
    Last Post: 04-23-2007, 06:22 AM
  3. Validation on import
    By andy_42 in forum Import/Export Data
    Replies: 1
    Last Post: 10-23-2006, 03:52 PM
  4. CSV File Import
    By compasst in forum Import/Export Data
    Replies: 3
    Last Post: 03-31-2006, 09:37 AM
  5. Import/Link Pictures into a table
    By shm138 in forum Import/Export Data
    Replies: 3
    Last Post: 03-17-2006, 08:12 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums