Selasa, 04 Oktober 2011

Re: [MS_AccessPros] Error fault from CSV file

 


Thanks Clive,

My apology for the delay. I've been busy on other matters.

I have now used the TYPE function and they are all type "1".

Regards,

Robin

At 4/10/2011 08:30 PM, you wrote:
>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
> > >
> > >
> > >
> >
>
>
>
>
>------------------------------------
>
>Yahoo! Groups Links
>
>
>

__._,_.___
Recent Activity:
MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

.

__,_._,___

Tidak ada komentar:

Posting Komentar