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