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
Tidak ada komentar:
Posting Komentar