Go Back   Access World Forums > Microsoft Access Discussion > Tables

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 12-12-2012, 10:51 AM   #1
jlwmkkp
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)

Hi,

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.

Thanks,
jlwmkkp

jlwmkkp is offline   Reply With Quote
Old 12-12-2012, 11:40 AM   #2
spikepl
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
Reply

Tags
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 12:57 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


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