Re: type conversion failure

From: JRS (JRS_at_discussions.microsoft.com)
Date: 01/31/05 

Date: Sun, 30 Jan 2005 21:01:02 -0800

these are the type of numbers causing the error.
9210 GH1 08526
when I look in desgin view....they say number everything else is text

"Ken Snell [MVP]" wrote:

> 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.
>
>
>