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

Rabu, 05 Oktober 2011

Re: [MS_AccessPros] Error fault from CSV file

Bill,

Yes my response is time stamped:

At 5/10/2011 07:31 PM, Robin Chapple wrote:

That is the day before your query. Repeated here:

Thanks Bill,

That gave me seven conversion errors:

Error Field Row
Type Conversion Failure Visitors 31
Type Conversion Failure Visitors 41
Type Conversion Failure Visitors 48
Type Conversion Failure Visitors 50
Type Conversion Failure Visitors 57
Type Conversion Failure Visitors 127
Type Conversion Failure Visitors 811

What do I read into that?

Regards,

Robin

At 6/10/2011 04:21 AM, you wrote:
>Robin - Did you try my suggestion? This thread is getting rather
>long so you might not have seen it.
>
>Bill
>
>--- In MS_Access_Professionals@yahoogroups.com, Robin Chapple
><robinski@...> wrote:
> >
> >
> > 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
> > >
> > >
> > >
> >
>
>
>
>
>------------------------------------
>
>Yahoo! Groups Links
>
>
>