Results 1 to 3 of 3
  1. #1
    jlmnjem is offline Novice
    Windows XP Access 2002 (version 10.0)
    Join Date
    Jul 2006
    Posts
    9

    Type error when importing Excel spreadsheet


    I'm trying to import an Excel spreadsheet as a table, but I'm getting an error. I have a spreadsheet of products, and the SKU field has part numbers. The first 44 part number are numbers only. Beginning on the 45th part number, there are numbers and letters in the part numbers. The error field in the import error table, beginning with the first record with a letter in the part number, indicates "type conversion failure". I've changed the format of that column to text in Excel with no luck. I've imported other spreadsheets with numbers and letters in the part numbers with no problems. Any ideas?

  2. #2
    Join Date
    Dec 2005
    Location
    Wilmington, DE - USA
    Posts
    275
    When you import from Excel, Access only looks at the first few rows to make its guesses as to data types.

    I am assuming that you were importing the data into a new table. If this is so, then just delete all the rows from that new table (but do not delete the table), go into the table design and change the field to text, and try reimporting the Excel data into that existing table.

  3. #3
    jlmnjem is offline Novice
    Windows XP Access 2002 (version 10.0)
    Join Date
    Jul 2006
    Posts
    9
    I'll try that. Thanks.

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

Similar Threads

  1. Importing Excel into Access with few requirements
    By pickolizac in forum Import/Export Data
    Replies: 1
    Last Post: 02-18-2009, 12:02 AM
  2. importing excel spreadsheet issues
    By majortool in forum Import/Export Data
    Replies: 1
    Last Post: 01-24-2008, 06:29 PM
  3. Importing from Excel
    By joer in forum Forms
    Replies: 0
    Last Post: 03-14-2007, 02:01 PM
  4. Importing Excel Sheet into Access dbase
    By tonystowe in forum Import/Export Data
    Replies: 0
    Last Post: 12-08-2006, 11:35 AM
  5. "Type Mismatch" Error
    By elmousa68 in forum Access
    Replies: 2
    Last Post: 12-05-2006, 08:28 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