Hi Robin,
To use the TYPE function enter it in the style
=TYPE(A1)
where A1 is the cell number.
It comes under the category 'Information'.
If you can't fix it, can you upload the .csv file
to the 2_AssistanceNeeded folder?
Regards, Clive.
--- In MS_Access_Professionals@yahoogroups.com, Robin Chapple <robinski@...> wrote:
>
>
> Thanks Graham,
>
> To test my theory I edited the CSV file and deleted the content. I
> them added the figures. The result was the same.
>
> Cheers,
>
> Robin
>
> At 4/10/2011 12:13 PM, you wrote:
> >Hi Robin
> >
> >You will get the #Num! error if the field is defined as numeric, but there
> >is non-numeric data in the cell. Are you *certain* that this is not the
> >case? Is it possible there is a problem with spaces in the field value?
> >
> >Best wishes,,
> >Graham
> >
> > > From: MS_Access_Professionals@yahoogroups.com
> >[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Robin Chapple
> > > Sent: Tuesday, 4 October 2011 11:02
> > > To: MS_Access_Professionals@yahoogroups.com
> > > Subject: [MS_AccessPros] Error fault from CSV file
> > >
> > >
> > > I have a statistical report delivered as a CSV file which shows an
> > > error, - #Num! , in a limited number of cases, 7 out of 811, when
> > > linked to Access.
> > >
> > > The CSV file has all numbers recorded.
> > >
> > > Where do I look for a solution to the problem?
> > >
> > > Many thanks,
> > >
> > > Robin Chapple
> >
> >
> >
> >------------------------------------
> >
> >Yahoo! Groups Links
> >
> >
> >
>
Tidak ada komentar:
Posting Komentar