Import to Existing Table (Type Conversion Failure) (1 Viewer)

jlwmkkp

New member
Local time
Today, 09:49
Joined
Nov 30, 2012
Messages
6
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
 

spikepl

Eledittingent Beliped
Local time
Today, 15:49
Joined
Nov 3, 2010
Messages
6,144
Set the format of that column in excel as text, instead of the default general
 

Users who are viewing this thread

Top Bottom