Hi Robin,
Make a copy of the .csv file and open it with Excel.
If you can't see anything wrong with the numbers
then try using the Excel TYPE function in an empty
column to the left of the suspect values and see what
value is returned.
If value is: TYPE returns:
Number 1
Text 2
Logical value 4
Error value 16
Array 64
The values returned should all be Type 1.
Alternatively, you can open the .csv file with a
text editor program like NotePad, Wordpad, or TextPad
and see if you can see anything peculiar about the
supect "numbers".
A possible fault could be that the 'nubers' have a
prefix and number nine looks like '9 instead of 9.
Regards, Clive.
--- In MS_Access_Professionals@yahoogroups.com, Robin Chapple <robinski@...> wrote:
>
> 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