Re: type conversion failure

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Ken Snell [MVP] (kthsneisllis9_at_ncoomcastt.renaetl)
Date: 01/31/05 

Date: Sun, 30 Jan 2005 22:00:25 -0500

When the import process is done, open the table that was created in design
view, and see what data type ACCESS/Jet is assigning to the field where the
numeric values are supposed to go. Is it something other than Number? If
yes, what? What types of numeric values are failing (ACCESS creates an error
table that tells you the row number in the EXCEL *** that failed)? 

-- 
        Ken Snell
<MS ACCESS MVP>
"JRS" <JRS@discussions.microsoft.com> wrote in message 
news:C2835471-A19D-43C5-8CCB-9517A12378EE@microsoft.com...
>I am impoting a excel spread*** into my access database as a new table. 
>I
> am getting an import error message.....type conversion failure....the 
> fields
> that are failing are numeric values.  I've tried changing them to text and
> number on the spread*** for iomporting and it does not work.  I've never
> had this problem before and I've used the source before.
Quantcast