Thanks Clive,
Now you have found a problem. I imported the CSV file. specified the
'visitor' field as text, ran a query on the table and sorted the
visitors field with this result:
Query1
ID Field1 Visitors
48 48 "1
41 41 "1
57 57 "2
127 127 "2
50 50 "2
31 31 "2
811 ** "41
26 26 0
9 9 0
764 764 1
The ID is an auto field by Access. The two asterisks have replaced a
blank field.
Regards,
Robin
At 6/10/2011 09:52 PM, you wrote:
>Hi Robin,
>
>Alternatively, import the .csv file but specify the
>dodgy Field as Type = Text.
>
>Regards, Clive.
>
>--- In MS_Access_Professionals@yahoogroups.com, "John Viescas"
><john@...> wrote:
> >
> > Robin-
> >
> > OK, what's in the Visitors column in rows 31, 41, 48, etc.
> ?? Look at the CSV
> > file in Notepad.
> >
> > John Viescas, author
> > Microsoft Office Access 2010 Inside Out
> > Microsoft Office Access 2007 Inside Out
> > Building Microsoft Access Applications
> > Microsoft Office Access 2003 Inside Out
> > SQL Queries for Mere Mortals
> > http://www.viescas.com/
> > (Paris, France)
> >
> >
> >
> > -----Original Message-----
> > From: MS_Access_Professionals@yahoogroups.com
> > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Robin Chapple
> > Sent: Thursday, October 06, 2011 1:52 AM
> > To: MS_Access_Professionals@yahoogroups.com
> > Subject: 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
> > >
> > >
> > >
> >
> >
> >
> >
> > ------------------------------------
> >
> > Yahoo! Groups Links
> >
>
>
>
>
>------------------------------------
>
>Yahoo! Groups Links
>
>
>
Tidak ada komentar:
Posting Komentar