Go Back   Access World Forums > Microsoft Access Discussion > Tables

Thread Tools Rate Thread Display Modes
Old 12-12-2012, 10:51 AM   #1
Newly Registered User
Join Date: Nov 2012
Posts: 6
Thanks: 2
Thanked 0 Times in 0 Posts
jlwmkkp is on a distinguished road
Import to Existing Table (Type Conversion Failure)


I need to import an excel spreadsheet into an existing Access 2003 table. Due to regulations, the spreadsheet cannot be linked.

When I try to import the spreadsheet, I receive a 'Type Conversion Failure' associated with a 'Product ID' field. In the Excel file, this column is populated with two types of values-- either a 9 digit number, or a 9 digit alpha numeric value. The 9 digit numbers import correctly, but the alpha numeric values fail.

Field names/layout in the excel spreadsheet are identical to the Access table, and the field type in the existing Access table is set to 'text.' There is no set Format, or Input Mask.

Does anyone have an idea about what I could change with the existing table to make this import work? I'd like to avoid importing a new table, as this would force me to recreate a number of relationships after each import.


jlwmkkp is offline   Reply With Quote
Old 12-12-2012, 11:40 AM   #2
Eledittingent Beliped
spikepl's Avatar
Join Date: Nov 2010
Location: San Serriffe
Posts: 6,144
Thanks: 77
Thanked 980 Times in 958 Posts
spikepl is a jewel in the rough spikepl is a jewel in the rough spikepl is a jewel in the rough
Re: Import to Existing Table (Type Conversion Failure)

Set the format of that column in excel as text, instead of the default general
spikepl is offline   Reply With Quote

access 2003 , import , table , type conversion failure

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Question Type Conversion Failure ldprenti General 3 10-03-2010 11:32 PM
Type Conversion Failure: Data Import Dave32 General 5 10-08-2008 04:46 AM
Supress "type conversion failure" message and continue with Import mrkipling Modules & VBA 4 06-16-2005 10:30 AM
Type Conversion Failure Error Message on Import andy_dyer General 3 02-27-2004 06:46 AM
'type conversion failure' import error hqengint Tables 5 08-28-2002 09:45 AM

All times are GMT -8. The time now is 10:37 AM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World