ACCESS FEED: RE: [MS_AccessPros] Error fault from CSV file

Selasa, 04 Oktober 2011

RE: [MS_AccessPros] Error fault from CSV file

Hi Robin

When you say you "edited the CSV file", what program did you use? CSV files
usually open by default using Excel, but they are not Excel files - they are
actually text files. Can you please try opening the file with Notepad and
see if there is anything different about the data in the dodgy fields?

Also, are you using a text import specification to link the data? If so,
what is the data type of the faulty numeric field? Perhaps it is Long
Integer, and the #Num! values have decimal parts, or something similar.

Please also open the linked table in design view (you will get a read-only
warning) and check the data type of the field in there.

Cheers,
Graham

> From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Robin Chapple
> Sent: Tuesday, 4 October 2011 15:32
> To: MS_Access_Professionals@yahoogroups.com
> Subject: RE: [MS_AccessPros] Error fault from CSV file
>
>
>
> 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